Color Change

S

scott45

Here is my formula =if(b1>0, 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
 
B

Bob Phillips

Use CF and test for equal to that value?

--

HTH

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

Peo Sjoblom

Use

cell value greater than 0 and format fonts the way you want
or use formula is

=B1>0

Regards,

Peo Sjoblom
 
A

Anne Troy

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
 
S

scott45

Thank you Anne!!!!!

Anne Troy said:
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
Click to expand...
 
Top