Date sensitive cell pattern color
 

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.

Date sensitive cell pattern color
 

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.

Date sensitive cell pattern color
 

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.

Date sensitive cell pattern color
 

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.

Date sensitive cell pattern color
 

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.