Menu
Ask a question Report

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

- - Latest reply: ac3mark
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 - Jul 20, 2016 at 05:53 PM
Excel Ask a question Report
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 

2 replies

Best answer
Report
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1537
1
Thank you
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!!


Say "Thank you" 1

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

CCM 6022 users have said thank you to us this month

Report
0
Thank you
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!
Report
ac3mark
Posts
13034
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
 1537 -
You are very welcome! Thanks for the feedback!
Ask a question