Operations with conditional formatting
I think I cannot use the same logic. I will try to explain what I want to do,
hope someone can help me.
I have a list of items I want to buy (in a column) from different sellers
(in a row). So I am formatting the cheapest price I can find from all the
sellers available I have. Now I want to know how much my total purchase would
be from each seller.
It is like I have a column with all the prices of a particular seller, and
some of them have a background yellow because it is the cheapest compared to
the other sellers. Now I want to sum all the yellow cells only.
Hope it is understandable. Thnaks
"T. Valko" wrote:
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
|