Dates older than 29 days

A

ab

I would like a column in my Excel spreadsheet to be made bold once the dates
in that column are more than 29 days old.
 
B

Bob Phillips

Use conditional formatting in say A1:A100 with a formula of =A1<TODAY()-29

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
D

Dave Peterson

One way is to use Format|Conditional formatting.

Cell Value is Less Than =today()-29

(use the dropdowns for the first two and type the last.)

And give it a nice old format.
 
Top