Want to change text color when a date is entered mm/dd/yy 1

[FYRGUY47]

I am sure it is conditional formatting, but stuck at the begining.

In cell A1 I have the word "date" shadded light gray. The cell is formatted to be a date mm/dd/yy. When I enter a date in that cell, I would like the color of the text to change to Black showing the date mm/dd/yy.

I thought I had a handle on how to do this through Conditional Formatting, but got stuck at the very begining.

Can anyone give me the steps please. I am not sure, I assume it is "cell value is", then what... between, not between, equal to, not equal to, etc..


Any help is appriciated!!

Chris

 

[SkipVought]

Hi.
[tt]
Cell Value is: equal to ="Date"
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[FYRGUY47]

Thanks Skip,
Please - I need more information.. I tried that and:

If I set it to - cell value ="date", the shaded out word "Date" changes to the black color. What I need is the word "Date" to stay the shaded gray color until the user types in a actual date (mm/dd/yy). At that point I wanted to actual date to turn black.

Maybe I am not explaining this very well... I hope this helps.

Thanks for your patients with me.

Chris

 

[SkipVought]

What about the opposite of equal to???

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[FYRGUY47]

THATS IT!!!

Thanks so much Skip! It works.

Catch you next time

Chris