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

Report
-
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
-
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

Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,684
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 4151 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!
ac3mark
Posts
13029
Registration date
Monday June 3, 2013
Status
Member
Last seen
October 11, 2019
1,684
You are very welcome! Thanks for the feedback!