conditional format with more than 3 conditions

[durul]

Hello,

I want to make conditional formatting but i have more than 3 conditions. Ie if the cell value is between 0 and 1 i need a diferent format and if it is between 1 and 2 an other an goes on like this. Total number of conditions should be 6. Any possibility to do it with conditional formatting or should i use something else?

Thanks

 

[tmischler]

You could try assigning a macro like this to the workbook change event or to a button?

Sub Macro2()

Dim MYVALUE As Long
Select Case MYVALUE

Case 1
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Case 2
With Selection.Interior
.ColorIndex = 8
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Case 3
With Selection.Interior
.ColorIndex = 12
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Case 4
With Selection.Interior
.ColorIndex = 16
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Case 5
With Selection.Interior
.ColorIndex = 20
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

Case Else
With Selection.Interior
.ColorIndex = 24
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

End Select

End Sub

 

[durul]

thanks but if i want the macro to execute the same in subsequent cells in a column and format according to the value of the cells.

 

[tmischler]

simply select the whole column before you run the macro.

If the column will always be the same or there is some consistent way of identifying the column then you can set the macro to do this automatically.