Forum Discussion
Formula to allow a cell to change colors based on score%
I am trying to create a formula so that the score cell will change colors based on the % of the total score that cell shows. Example would be if the cell shows 1-400 and total points is 1600 then the cell would show a red background. 401-800 would be yellow, 801 to 1200 would be amber and 1201 - 1600 would be green.
So one cell would show that locations scores and another cell would show maximum number of points available.
1 Reply
James,
Simply, you can do that by using Conditional Formatting!
Go to Home >> Styles >> Conditional Formatting >> Highlight Cells Rules >> Between...
After that, apply the rules one by one on the score cell.
First rule from 1 to 400 with red fill, second rule from 401 to 800 with yellow fill, and so on...
Please find the attachment file.
