Does anybody know how to have more than 3 conditions
on one cell for instance I need 6 different colour conditions
so if conditions:
1 ) Cell Value in A1 = "C" colour needs to be in red
2 ) Cell Value in A1 = "H" colour needs to be in yellow
3 ) Cell Value in A1 = "N" colour needs to be in green
4 ) Cell Value in A1 = "S" colour needs to be in blue
5 ) Cell Value in A1 = "L" colour needs to be in black
6 ) Cell Value in A1 = "D" colour needs to be in gray
unfortunately I have discovered that there is a limitation of 3 conditions
so how can I add more conditions ????
any help is highly appreciated
thanks
franko
on one cell for instance I need 6 different colour conditions
so if conditions:
1 ) Cell Value in A1 = "C" colour needs to be in red
2 ) Cell Value in A1 = "H" colour needs to be in yellow
3 ) Cell Value in A1 = "N" colour needs to be in green
4 ) Cell Value in A1 = "S" colour needs to be in blue
5 ) Cell Value in A1 = "L" colour needs to be in black
6 ) Cell Value in A1 = "D" colour needs to be in gray
unfortunately I have discovered that there is a limitation of 3 conditions
so how can I add more conditions ????
any help is highly appreciated

thanks
franko