Conditional Formating a column
Solved/Closed
Related:
- Conditional Formating a column
- Excel conditional formatting entire column based on another column ✓ - Forum - Excel
- Excel conditional formatting if column contains specific text ✓ - Forum - Excel
- Conditional formatting multiple columns independently ✓ - Forum - Excel
- Highlight cell if another cell contains any text ✓ - Forum - Excel
- Conditional formatting column vs column - Guide
1 reply
Mazzaropi
Oct 8, 2015 at 09:34 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
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