I am wondering if it is possible to format a cell that contains text - based on a number in the cell next to it. Here is what I have:
Category......Mean
Results.........3.3
Morale..........3.8
Buy-In..........4.0
I would like the word 'Results' to display in BLACK text because the mean score is in the range 3.0-3.9 (same goes for the word 'Morale')
I would like the word 'Buy-In' to disply in GREEN text because the mean score is in the range 4.0-5.0
Basically, the mean scores are calculated using formulas and I would like the color of the category to change based on the mean score number.
Is there a way to use conditional formatting to do this? Or another way to automatically make this work?
File is attached.
Thanks!
Sarah
Bookmarks