rrosa1
02-27-2011, 05:00 PM
hi i have following code to add cond.formating but in column there is "0" in cell
so it formet that cell but i need to find small num. in column not the zero
is there any way i can do that?
thanks for looking my requestcl
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=OR(RC=SMALL(R4C:R367C,1),RC=SMALL(R4C:R367C,2))" For Each cl In rng
Select Case cl.Value
Case Is = 0
Case Is = ""
Case Else
With rng.FormatConditions(2)
With .Font
.Bold = True
.ColorIndex = 5 '3
End With
'.Interior.ColorIndex = 39
End With
End Select
Next
so it formet that cell but i need to find small num. in column not the zero
is there any way i can do that?
thanks for looking my requestcl
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=OR(RC=SMALL(R4C:R367C,1),RC=SMALL(R4C:R367C,2))" For Each cl In rng
Select Case cl.Value
Case Is = 0
Case Is = ""
Case Else
With rng.FormatConditions(2)
With .Font
.Bold = True
.ColorIndex = 5 '3
End With
'.Interior.ColorIndex = 39
End With
End Select
Next