Color code excel cells according to scores
Solved/Closed
Liz
-
Dec 13, 2011 at 08:26 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 13, 2011 at 09:48 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 13, 2011 at 09:48 PM
Related:
- Color code excel cells according to scores
- Battery reset code - Guide
- How to get whatsapp verification code online - Guide
- Samsung volume increase code - Guide
- Sound card color code - Guide
- Cat5e color code - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 13, 2011 at 09:48 PM
Dec 13, 2011 at 09:48 PM
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"
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"
