Conditional Formating a column
Solved/Closed
Related:
- Conditional Formating a column
- How to delete a column in word - Guide
- Excel conditional formatting based on date - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- Excel column to number - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
8 Oct 2015 à 09:34
8 Oct 2015 à 09:34
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
8 Oct 2015 à 10:32