Thread: Color Change
View Single Post
  #6   Report Post  
Anne Troy
 
Posts: n/a
Default

You're welcome!!
************
Anne Troy
www.OfficeArticles.com

"scott45" wrote in message
...
Thank you Anne!!!!!

"Anne Troy" wrote:

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