[Pierre]

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?????

[Bernard Liengme]

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?????

[Pierre]

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

[Fred Smith[_4_]]

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

[Pierre]

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

[Fred Smith[_4_]]

"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

[Pierre]

dear mr fred i apologize for this inconvenience...

again:
today is as we speak : 07/06/2008
i have inserted in cell A1 : 10/06/2008

which means that if i would like to open my excel file again after 3
days.....i want cell A1 to be colored in red .........because this wanted
date has been reached

thanks for your patience and for your
help






"Fred Smith" wrote:

"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

[Fred Smith[_4_]]

Then use:

=A1<=today()

Regards,
Fred.

"pierre" wrote in message
...

dear mr fred i apologize for this inconvenience...

again:
today is as we speak : 07/06/2008
i have inserted in cell A1 : 10/06/2008

which means that if i would like to open my excel file again after 3
days.....i want cell A1 to be colored in red .........because this wanted
date has been reached

thanks for your patience and for your
help






"Fred Smith" wrote:

"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