Report

Conditional Formating: formula cell text change color [Solved]

Ask a question Marshall - Latest answer 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 5829Posts Monday June 3, 2013Registration date ModeratorStatus September 23, 2016 Last seen - Jul 20, 2016 05:53PM
You are very welcome! Thanks for the feedback!
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!