That did it. Thank you very much.
ds
"Sloth" wrote in message
...
1. Select the cell in question

2. Select Format-Conditional Formatting

3. Select "Formula Is"

4. Enter this formula
=TODAY()=DATEVALUE("8/15/2006")

6. Click Format, and select the pattern you want.

7. Click Ok

Replace 8/15/2006 with the date you want to use, but be sure to keep the
quotes around the date. If the date is in the cell then use the cell
reference in the formula like this...

=TODAY()=A1

or use "Cell Value Is" - "Less than or equal to" - =TODAY()

Whichever way you choose the cell pattern will change when the current
date
has reached the date in question.

"Darrell Shuman" wrote:

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.