Report

Conditional Formating: formula cell text change color [Solved]

Ask a question Marshall - Last answered on Jul 20, 2016 05:53PM
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!
See more 
Helpful
+0
moins plus
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!!



Add comment
Helpful
+0
moins plus
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 6225Posts Monday June 3, 2013Registration date ModeratorStatus December 9, 2016 Last seen - Jul 20, 2016 05:53PM
You are very welcome! Thanks for the feedback!
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!