In Excel, can Boolean logic be applied to conditional formatting?

P

PeterL

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
 
B

Barb Reinhardt

I'm not sure what you want to do with the background color. Can you explain
it differently?
 
J

Jim Thomlinson

No you can not count colours generated by a conditional foramt. You can
however use the logic of the conditional format along with either a
sumproduct or an array formula to generate the count... Check out this link
on sumproduct. There is also a discussion about counting colours at this web
site...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
 
B

Barb Reinhardt

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
 
Top