Extending conditional formatting

[FergusonRK]

Hi Folks,

Excel Newbie needs to know if there is a way to do conditional formatting on more than three data elements... Excel only provides the capability to select three elements, can this be increased by some configuration setting within Excel or by script?

Thanks much,

Fergie

 

[Gerald Higgins]

You can get it to four by using the default format.

If you only want text colours, you can get a fifth by using custom formats

Otherwise, I think you'll need VBA.

 

[ADAMC]

Not sure if this helps but its something i use:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value <= 10 Then Target.Interior.ColorIndex = 1
If Target.Value > 10 And Target.Value <= 20 Then Target.Interior.ColorIndex = 3
If Target.Value > 20 And Target.Value <= 30 Then Target.Interior.ColorIndex = 4
If Target.Value > 30 And Target.Value <= 40 Then Target.Interior.ColorIndex = 5
If Target.Value > 40 And Target.Value <= 50 Then Target.Interior.ColorIndex = 6
If Target.Value > 50 And Target.Value <= 60 Then Target.Interior.ColorIndex = 7
End Sub

I have 5 conditions but i imagine you could add as many as required.