Conditional Formatting

[George]

What would I use for a formula to change the cell background color, if the
date entered in the cell is older then today's current date.

Thanks - George

[aristotle]

Hi,

Go to Format -> Conditional Formatting.

Formula: =today()<A1

Regards,
A

"George" wrote:

> What would I use for a formula to change the cell background color, if the
> date entered in the cell is older then today's current date.
>
> Thanks - George
>
>

[George]

Aristotle - I tryed your formula and it sort of works. As long as there is a
value in the cell and the date is older then todays date then the background
color kicks in. But if you clear the date entered in the field the background
color stays.

To add a little more detail to what I am doing - I have rows of dates - each
row of cells already has this conditional format:

=IF(COUNTIF(4:4,B4)>1,TRUE,FALSE)

Which detects any duplicate dates - which works great - just need something
to point expired dates.

Thanks - George

"aristotle" wrote:

> Hi,
>
> Go to Format -> Conditional Formatting.
>
> Formula: =today()<A1
>
> Regards,
> A
>
> "George" wrote:
>
> > What would I use for a formula to change the cell background color, if the
> > date entered in the cell is older then today's current date.
> >
> > Thanks - George
> >
> >