Color code excel cells according to scores [Closed]

- - Latest reply: venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
- Dec 13, 2011 at 09:48 PM
Hello, How do I color code cells in excel ti turn colors according to scores--such as red (0-69%), yellow 70-89%), green 90-100%)?

Thank you,
E. R.



See more 

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
784
0
Thank you
DO CONDITIONAL FORMATTING

highlight all the cells under reference
click format-conditional formatting

highlight all the cells under reference
click format-=conditional formatting(CF)

in CF window
condition1
"the cell value is "
keep
between
in the small window next
next window type 0
in the last small window type
69
if you entered as number the above is ok
if you have entered something like 45% then make 0% and 69% above
click format in the second row of the CF window
in the format window choose "pattern" at the top
color shades will come up choose color and click ok
you are back CF window

next click "add" in the bottom
repeat the same steps except the nummbers are no 70 and 69

again when you come back to CF window repeat steps with numbers as 70 and 100
when you come back to CF
click ok

now see

read help under "conditional formatting"