Conditional Formating a column
Solved/Closed
Hello,
I wish to conditionally format a column depending on another columns date value in excel 2010
Column A has a target date and Column B has the completion date. I want column B to show red if target date is greater than completion date and green if it is less than or equal to completion date.
I have managened to do this to two corresponding cells but not the whole column
I wish to conditionally format a column depending on another columns date value in excel 2010
Column A has a target date and Column B has the completion date. I want column B to show red if target date is greater than completion date and green if it is less than or equal to completion date.
I have managened to do this to two corresponding cells but not the whole column
Related:
- Conditional Formating a column
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
- Excel count occurrences of string in column - Guide
- How to format a usb on mac - Guide
- Excel vba find last non empty cell in column - Guide
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