date thing

P

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

Bernard Liengme

Select the cell; use Format | Conditional Format
Formula Is: =A1-TODAY()<3 ... then Format as needed
best wishes
 
P

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
 
F

Fred Smith

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

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

Fred Smith

"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.
 
P

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
 
F

Fred Smith

Then use:

=A1<=today()

Regards,
Fred.

pierre said:
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
Click to expand...
 
Top