Use Cell value is and type "Enter Date" into the box. Then choose the color
you want the font or cell background to be. This should be a no-brainer.
Perhaps you're doing what I do... miss the simplest step! :)
************
Anne Troy
www.OfficeArticles.com
"scott45" wrote in message
...
Here is my formula =if(b10, b2, "Enter Date") Is it possible to have
Enter
Date in a different color since it is false? I can not seem to find
anything
under conditional formatting
Thank you in advance
Scott