Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting ... shade cell ... older than today
How can I use conditional formatting to shade the cell if its value is older
than today? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting ... shade cell ... older than today
Use a formula of
=A1<TODAY() assuming the cell is A1. -- HTH RP (remove nothere from the email address if mailing direct) "Mirsten Choiple" wrote in message ... How can I use conditional formatting to shade the cell if its value is older than today? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting ... shade cell ... older than today
If you want to use the default Cell Value Is dialogs rather than Formula is,
then Select all the cells you want to format and do format=Conditional Format Cell value is Less than =today()-1 if you want to allow for blank cells Cell value is between 1 and =today()-1 -- Regards, Tom Ogilvy "Mirsten Choiple" wrote in message ... How can I use conditional formatting to shade the cell if its value is older than today? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting €“ shade all cells in row | Excel Discussion (Misc queries) | |||
Conditional Formatting on 'Today' | Setting up and Configuration of Excel | |||
Computing days between TODAY() and older date in a cell | Excel Discussion (Misc queries) | |||
Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
How to shade a row of cells using conditional formatting | Excel Worksheet Functions |