Excel 2007 - I am trying to sum the numbers in a row (D2:V2) and if the cells
are highlighted in green or orange I want the numbers added. I am using the
sumcolor module. It works if I manually color/highlight the cell. However I
have the cell highlighted based on conditional formatting (for example: green
= numbers over 50,000) then the sumcolor function will not work. It won't
pick up the cells that are highlighted by conditional formatting. Here is my
formula:
=sumcolor($A$2,B7:V7)+sumcolor($A$3,B7:V7)

A2 (green) and A3 (orange) are the blank colored cells for reference. B7:V7
is the data I want to analyze and sum.

Can this be done with conditional formatting on?