Forum Discussion
Excel colour formatting based off value
Hey, I have a 10 point scale (1,2,3,4,5,6,7,8,9,10) and each number has a set colour attacthed to it. I then have names on the left and for example, uniform and behaviour on the top row, so each week...
Go to Conditional Formatting on the Home tab of the ribbon. Select New rule > Use a formula to determine which cells to format. Then, type this one:
=C3=1
Note that the reference of C3 is not absolute. Then, select to fill with red color on the fill tab and change font color (on the font tab) with the same color you filled the cell (this will make the number not visible). Do the same procedure for all points in the scale.
Finally, once you have all rules set, go to manage rules in the conditional formatting options and change the range of "Applies to" to select the entire desired range of application.
I have created a sample sheet with a 3 point scale. Red for 1, orange for 2 and green for 3. Please see attached sample book for a better reference.
Martin
- Is there any way to do this in google spreadsheets?
