i have in A1 the following date: 06/10/2008
i would like to say :
if i reach in a few days this date , turn it to red color

how to do that?????

Select the cell; use Format | Conditional Format
Formula Is: =A1-TODAY()<3 ... then Format as needed
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"pierre" wrote in message
...
i have in A1 the following date: 06/10/2008
i would like to say :
if i reach in a few days this date , turn it to red color

how to do that?????

what does the 3 stand for ??

one more thing .....if i would loke to use the time here with red color as
well ...what should i use ???


thanks

Since you didn't tell use what "few days" means, Bernard chose 3 for his
example. Change the 3 to whatever you mean as "few days".

He also addressed your "red color" issue. Use the format button in
conditional formatting to color the cell.

If you still have problems, post back telling us what you have done, what
the results are, and what results you wanted instread.

Regards,
Fred.

"pierre" wrote in message
...
what does the 3 stand for ??

one more thing .....if i would loke to use the time here with red color as
well ...what should i use ???


thanks

it doesnt work...
what i am doing is that i am inserting a future date , and i am saying that
if the future date is reached in the due day ,change this date to red
what is happening with me is that it changes to red automatically after
doing the conditional format...although i want it to be in the due day...
how to do that ????




"Fred Smith" wrote:

Since you didn't tell use what "few days" means, Bernard chose 3 for his
example. Change the 3 to whatever you mean as "few days".

He also addressed your "red color" issue. Use the format button in
conditional formatting to color the cell.

If you still have problems, post back telling us what you have done, what
the results are, and what results you wanted instread.

Regards,
Fred.

"pierre" wrote in message
...
what does the 3 stand for ??

one more thing .....if i would loke to use the time here with red color as
well ...what should i use ???


thanks

"How to do that ????"
Ask a question that's understandable.

You started off by saying you had 06/10/2008 in A1. If you reached it in a
"few days" you wanted it turned red. Now you say "if the future date is
reached in the due day" change it to red.

So to answer your question, we need to know what is the "due day". Is it
today? Is it a date in some other cell? Is it something else?

Clear questions get very quick answers on this forum. That's all we need.

Regards,
Fred.

"pierre" wrote in message
...
it doesnt work...
what i am doing is that i am inserting a future date , and i am saying
that
if the future date is reached in the due day ,change this date to red
what is happening with me is that it changes to red automatically after
doing the conditional format...although i want it to be in the due day...
how to do that ????




"Fred Smith" wrote:

Since you didn't tell use what "few days" means, Bernard chose 3 for his
example. Change the 3 to whatever you mean as "few days".

He also addressed your "red color" issue. Use the format button in
conditional formatting to color the cell.

If you still have problems, post back telling us what you have done, what
the results are, and what results you wanted instread.

Regards,
Fred.

"pierre" wrote in message
...
what does the 3 stand for ??

one more thing .....if i would loke to use the time here with red color
as
well ...what should i use ???


thanks