Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is there any way to have more than 3 conditional formats per cell | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) |