Thanks Marcelo, but how can I enter some future date and when that date
comes the cell turns red? I can't find a way to enter the IF and DATE
function in the conditional format.
ds
"Marcelo" wrote in message
...
hi, Darrell,

try to use conditional format (Fomart | Conditional Format)

hth

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Darrell Shuman" escreveu:

Greetings,
How can I set up a cell's pattern color to automatically change to red
when
a certain date arrives? I would hope it could be done without VB as my
knowledge is very limited.
Thanks for your help.