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" <ab@discussions.microsoft.com> wrote in message
news:18DFF729-4B1D-4200-A348-B0F2D29282F6@microsoft.com...
> 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