Why can't I use more than 3 conditional formats per cell?
 

I want to format an excel cell to show a different color if the result falls
within 5 ranges. Currently, I can only utilize three of the five format
conditions. Is there a way to show more than that? ( I am using this as a
score card for my department.)

Why can't I use more than 3 conditional formats per cell?
 

http://mcgimpsey.com/excel/conditional6.html

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jillian R" escreveu:

I want to format an excel cell to show a different color if the result falls
within 5 ranges. Currently, I can only utilize three of the five format
conditions. Is there a way to show more than that? ( I am using this as a
score card for my department.)