Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting
What would I use for a formula to change the cell background color, if the
date entered in the cell is older then today's current date. Thanks - George |
#2
|
|||
|
|||
Hi,
Go to Format - Conditional Formatting. Formula: =today()<A1 Regards, A "George" wrote: What would I use for a formula to change the cell background color, if the date entered in the cell is older then today's current date. Thanks - George |
#3
|
|||
|
|||
Aristotle - I tryed your formula and it sort of works. As long as there is a
value in the cell and the date is older then todays date then the background color kicks in. But if you clear the date entered in the field the background color stays. To add a little more detail to what I am doing - I have rows of dates - each row of cells already has this conditional format: =IF(COUNTIF(4:4,B4)1,TRUE,FALSE) Which detects any duplicate dates - which works great - just need something to point expired dates. Thanks - George "aristotle" wrote: Hi, Go to Format - Conditional Formatting. Formula: =today()<A1 Regards, A "George" wrote: What would I use for a formula to change the cell background color, if the date entered in the cell is older then today's current date. Thanks - George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |