One way summarize data that has been higlighted is to add a column in the
worksheet. Then use copy - past special to copy the formatting only to the
new blank column from one of the columns that has highlighted data.

Then use Find & Rreplace with Opitons to search the new column for the cells
with the color, then replace with the same formatting, but with the word
added that applies to the color, i.e., "good". You will have to do these for
each color used to higlight the data. Shouldn't take long if you only have
three conditional colors.

You will now have a column that can be used to sumif based on the name,
i.e., "good". Also, you can use the column to pivot the data.



"benmormedical" wrote:

I have created a worksheet with a list of quotes that are either outstanding
or have produced a sale and I am using the good, bad and neutral styles to
distinguish which is which, eg. a quote that has resulted in a sale is
highlighted as 'good' (light green shading with a dark green font).
I want a cell at the top of the sheet that adds all of the outstanding
quotes together to show how much possible revenue is outstanding, I have
tried using the SUMIF function but I dont know how to describe the cells when
writing the formula so that it only adds the outstanding ones.

help? :S