Color Change

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use CF and test for equal to that value?

--

HTH

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

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

=B1>0

Regards,

Peo Sjoblom
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Macro to automatically go to the right of the last colored cell 0
IF OR AND in same conditional formula 2
Using Dates in Conditional Formatting 9
Conditional format stoplight based on worst color 3
Using Three Conditions in CF 3
Conditoinal formatting 2
Does anyone have any suggesitons on how to do it for worksheet? 1
Conditional Formatting Driving Me Crazy 1

Back
Top