Conditional Formatting

[Guest]

I am wanting to diplay a number of results using colour codes ie 2=red,
3=blue, 4=green.... Conditional formatting only lets you use three
conditions in one cell at a time, I need at least 20. Is their another way
around this?

Thanks for your help

 

[Guest]

You can assign differenct conditiononal formats to each
cell, so if you only need 3 rules per column/row/area, you
can work it that was, otherwise your stumped unless you
write a macro to do your coulouring in.
jonny

 

[Marshall Barton]

I am wanting to diplay a number of results using colour codes ie 2=red,
3=blue, 4=green.... Conditional formatting only lets you use three
conditions in one cell at a time, I need at least 20. Is their another way
around this?

Use VBA code in the Format event procedure:

Select Case colorcode
Case 2
lngColor = vbRed
Case 3
lngColor = vbBlue
Case 4
lngColor = vbGreen
Case 5
lngColor = RGB(255, 127, 0) 'Orange
. . .
Case Else
lngColor = vbBlack
End Select
Me.textbox1.ForeColor = lngColor
Me.textbox2.ForeColor = lngColor
. . .