Report

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

Ask a question Marshall - Last answered on Jul 20, 2016 at 05:53 PM by ac3mark
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
plus moins
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 7331Posts Monday June 3, 2013Registration date ModeratorStatus July 20, 2017 Last seen - Jul 20, 2016 at 05:53 PM
You are very welcome! Thanks for the feedback!
Helpful
-1
plus moins
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!!



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!