sum cells that have been identified using conditional formatting

F

Frank Kabel

Hi
though this is possibel (but only with a complicated user defined
function) it would be easier to sum based on the same conditions as
your conditional format using SUMIF or SUMPRODUCT.
If you could give some more information about your conditions this
should be easy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can i put text in a cell depending on colour 0
conditional formatting update issue 5
Change the colour of a cell if another named cell is blank 2
Conditional fomatting for cells containing a Comment 9
Conditional format 1
Conditional Formatting 3
Conditional Formatting with VBA 4
Excel does not accept text format! 0

Top