Date sensitive cell pattern color

D

Darrell Shuman

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.
 
M

Marcelo

hi, Darrell,

try to use conditional format (Fomart | Conditional Format)

hth

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



"Darrell Shuman" escreveu:
 
D

Darrell Shuman

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
 
S

Sloth

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.
 
D

Darrell Shuman

That did it. Thank you very much.
ds
Sloth said:
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.
Click to expand...
 
Top