This function may be of use to you

Function CFCount(rng)

Dim rng As Range
Dim cc As Range

Set rng = ActiveSheet.UsedRange
i = 0
For Each cc In rng
If cc.FormatConditions.Count 0 Then
i = i + 1
'this cell has conditional formatting
' so handle it here

End If
Next
CFCount = i
End Function



"PeterL" wrote:

I have a spreadsheet where I have used conditional formatting to have cell
change color under certain conditions. Is there a way to apply Boolean logic
to the changing background color? Or is manually counting the cells the only
option?

Thanks,

Peter