Thread: Color Change
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Use CF and test for equal to that value?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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