| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
shade cells based on conditions - i have more than 3 conditions
example:
IF A2 = "1", shade cell E4 "green" if A2 = 2, shade e4 blue if 3, shade yellow if 4, shade brown if 5, shade orange if 6, shade purple if 7, shade black Conditional formatting will only cover 3 conditions..so u see my problem.. so How would i do this? is it possible to shade a cell as a result of an IF statement yielding true/false? (i'm looking for a way without resorting to vb code, as i dont know much about it... but if there is no other way, i'm willing to learn) thanks in advance for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statement to shade cells (more than 3 conditions) | Excel Discussion (Misc queries) | |||
| IF condition is true, shade cell (more than 3 conditions) | Excel Discussion (Misc queries) | |||
| Conditionally summing cells based on conditions in other rows | Excel Worksheet Functions | |||
| Add cells from a range based on 2 conditions from 2 other ranges | Excel Worksheet Functions | |||
| count number of cells based on TWO conditions (2 different columns | Excel Worksheet Functions | |||
Threaded Mode
