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

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

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

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

"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

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

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
--
HTH...

Jim Thomlinson


"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

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

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