"How to show a Date Expiry using formatting in Excel"

[keves2002]

hi,​

I am having an "Excel" sheet with "Dates" in a column, Lets say the Date i am having in "cell A1" is 17/07/07, what i need is when the date is 30/07/07 [0r any future date ] it shud blink or show some kind of formatting like color change or something like that, I don’t want to use any 3rd party software for this, just wanna know is it possible to do with Excel ​

Thanx in advance
keves​

 

[Ramakrishnan]

Suppose you want to show the date in red color when it is say 30/7/2007. Follow along:

put your cusor in the cell which you want to format
enter the date separately(in this case 30/7/2007) somewhere on your sheet where there is less likelihood of its being disturbed.
Go to format>conditional format
select "cell value is" in the dropdown and select "equal to " in the next dropdown box. Lastly give the path to the date you entered in the second step. click the format button and give some color (there are many other things also you can do here).

That is all.

There may be other methods also.

 

[keves2002]

Thanx a lot it worked , when i tried this first i was giving reference to the same Cell

Regards
Keves