date formulas

K

Karl

I have the current, automatically updated date displayed on my spreadsheet.
How can I get the other dates on my spreadsheet to automatically change fill
colors when they become older than 30 days?
 
B

BoniM

Select the range of dates you wish to format. Select format > conditional
formatting > change from Cell Value Is: to Formula Is: and enter a formula
similar to:

=$A$3-A5>30

This formula has todays date in A3 and the date range starts in A5, edit as
needed. Click the format button to change formatting of any cell that meets
the older than 30 days criteria.
Have fun!
 
Top