Dates older than 29 days
 

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.

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)


"ab" wrote in message
...
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.

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.

ab wrote:

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.

--

Dave Peterson