Conditional Formating: formula cell text change color [Solved/Closed]

Report
-
 Blocked Profile -
Hello,

How do I get Text in a Cell to Change from Black to White, based on data?

The cell already contains a formula to extract data from elsewhere. I need that cell text to then be either Black or White, depending on if there is text or numbers.

Text = Black
Numbers = White

The formula being used already is ='Blank Daily Tracking'!E89

I have conditional formatting icon, but don't see which is the best way to set the IF clause up.

Thanks!


2 replies


Select NEW Rule>Use a Formula to determine which cells to format. Place your formula in the Edit description box, and click on the FORMAT BUTTON! VIOLA! Go for it!!



1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

THanks for the quick reply!!! I actually sat at my desk for about 30 minutes and was able to figure it out. I was able to quickly format the 0s to White. The date was a challenge because you can't go to "date" to make the format change. I went to "unique" cell value and changed it that way.

When I think about it, it was relatively easy!

Thanks!
Blocked Profile
You are very welcome! Thanks for the feedback!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!