Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
Is it possible to format a cell, that contains a date, to change color after
30 days have passed since that date? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting
Yes
Using the formula facility in Conditional Formatting If your date is in C4, then....... Formula is.. =TODAY()-C430 then click the Format button and select your formatting for when this condition is true "vdefilippo" wrote: Is it possible to format a cell, that contains a date, to change color after 30 days have passed since that date? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |