Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need more than 2 conditions in Conditional Formatting
Is there a way to have more than just the 3 conditions in formatting or to
work around it? I have a range of b4:b35 and I need to highlight cell different colors depending on cell value.. If cell =0 then fill with red if cell =1 then fill with yellow if cell = 2 then fill with green if cell = 3 then fill with blue if cell =off then fill with grey so as of right now I need 5 conditions unless oen of you wonderful experts out there have an alternative solution for me.... thank you in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have more than 6 conditions when using conditional formatting? | Excel Worksheet Functions | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Conditional formatting capability for 20+ conditions not just 3. | Excel Discussion (Misc queries) | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |