If the cells are *conditionally formatted* then you can use the same logic
that was used to apply the conditional formatting to then write a formula to
do what you want.

--
Biff
Microsoft Excel MVP


"Lily" wrote in message
...
Can I apply some operations based on cells that have conditional
formating?.
I want to count the number of customer that have a specific format I set
up.
Something like a CountIf or SumIf, but based on format.
Thanks