Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOW TO HAVE MORE THAN THREE CONDITIONS IN CONDITIONAL FORMATS ?
I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX
CRITERIA,ANY IDEAS? |
#2
|
|||
|
|||
nested if statement
substitute appropriately; assuming trigger is in cell H1 =IF(H1=1,"color1",IF(H1=2,"color2",IF(H1=3,"color3 ",IF(H1=4,"color4",IF(H1=5,"color5",IF(H1=6,"color 6","No color")))))) Good luck "HELP NEEDED" wrote: I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX CRITERIA,ANY IDEAS? |
#3
|
|||
|
|||
That won't work
-- Regards, Peo Sjoblom "jennifer" wrote in message ... nested if statement substitute appropriately; assuming trigger is in cell H1 =IF(H1=1,"color1",IF(H1=2,"color2",IF(H1=3,"color3 ",IF(H1=4,"color4",IF(H1=5,"color5",IF(H1=6,"color 6","No color")))))) Good luck "HELP NEEDED" wrote: I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX CRITERIA,ANY IDEAS? |
#4
|
|||
|
|||
Hi Jennifer
this formula will return the literal text statements "color1", "color2" etc rather than colouring the cells like conditional formatting would do (format / conditional formatting). Unfortunately, a formula can not change the formatting of a cell. The only options are the ones that Peo mentioned or the use of VBA. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "jennifer" wrote in message ... nested if statement substitute appropriately; assuming trigger is in cell H1 =IF(H1=1,"color1",IF(H1=2,"color2",IF(H1=3,"color3 ",IF(H1=4,"color4",IF(H1=5,"color5",IF(H1=6,"color 6","No color")))))) Good luck "HELP NEEDED" wrote: I WOULD LIKE A CELL TO RETURN A DIFFERENT COLOR FOR EACH OF MY SIX CRITERIA,ANY IDEAS? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |