I have a spreadsheet where in one column I have several groups of names that need to be highlighted in certain colors dependant on the values coming up in a different column.
In column D rows 6 through 36 and rows 40 through 56 there are names.
In column G (equivalent rows to D) there are values ranging from zero to one hundred percent.
What I need is for the values in column G to deterkine the coor of the cells in column D.
100 = red
75 to 100 (75 included 100 excluded) = orange
50 to 75 (50 included 75 excluded) = yellow
25 to 50 (25 included 50 excluded) = pale yellow
0 to 25 (0 and 25 excluded) = green
0 = pale grey
If there is any more info needed to make this clearer just ask, any insight would be greatly appreciated!
Bookmarks