Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting - 6 conditions
Hi,
Conditional formatting allows for 3 conditions. I require 6 for the following ranges of data in a field spannin A1 to G50 0-0.1 pale yellow 0.1-0.25 yellow 0.25-1.0 pale orange 1.0-1.5 orange 1.5-2.0 pale red 2.0 red I guess an IF, THEN statement might work? Can anyone help? Thanks, Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use 2 conditions in conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting - more than 3 conditions | Excel Discussion (Misc queries) | |||
Conditional formatting - with 2 conditions | Excel Discussion (Misc queries) | |||
Conditional formatting should allow more than three conditions. | Excel Discussion (Misc queries) | |||
Conditional Formatting with more than 3 conditions | Excel Programming |