Color Change
 

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

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

Use

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

=B10

Regards,

Peo Sjoblom
"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

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

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

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