Conditional Formating a column
Solved/Closed
Related:
- Conditional Formating a column
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- Vba find column by name ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to convert row to column in notepad++ ✓ - Excel Forum
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Oct 8, 2015 at 09:34 AM
Oct 8, 2015 at 09:34 AM
Ian, Good morning.
The logic that you described is very unusual to be applied in this case.
It is opposed to the type of control that is done.
But given your exact request, do:
Select dates at column B
Conditional Format Menu
Using Formula
Rule 1
=A2>B2
Format; Fill: RED
Rule 2
=A2<=B2
Format; Fill: GREEN
OK
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
The logic that you described is very unusual to be applied in this case.
It is opposed to the type of control that is done.
But given your exact request, do:
Select dates at column B
Conditional Format Menu
Using Formula
Rule 1
=A2>B2
Format; Fill: RED
Rule 2
=A2<=B2
Format; Fill: GREEN
OK
Is this what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Oct 8, 2015 at 10:32 AM