i have having trouble finding a function that will allow me to make the cell
change red if the date that is entered into that cell becomes older than the
current date. if anyone can help me that would be great.
thanks

Formatconditional formatting, formula is

=A1<TODAY()

select a red pattern/font

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"awilliams" wrote in message
...
i have having trouble finding a function that will allow me to make the
cell
change red if the date that is entered into that cell becomes older than
the
current date. if anyone can help me that would be great.
thanks

If you do a Conditional Formatting like this:

Cell Value Is
less than
=NOW()

And set the desired formatting with the Format button.

"awilliams" wrote:

i have having trouble finding a function that will allow me to make the cell
change red if the date that is entered into that cell becomes older than the
current date. if anyone can help me that would be great.
thanks

you could use conditional format

regards from Brazil
Marcelo

"awilliams" escreveu:

i have having trouble finding a function that will allow me to make the cell
change red if the date that is entered into that cell becomes older than the
current date. if anyone can help me that would be great.
thanks

in Conditional formatting, select column e.g. colA and:

Formula is: =AND(A1<today(),A1<"")

select colour

HTH

"awilliams" wrote:

i have having trouble finding a function that will allow me to make the cell
change red if the date that is entered into that cell becomes older than the
current date. if anyone can help me that would be great.
thanks