A formula cannot work with the color of the cell/font. VBA is needed for
that. However, a formula can work with the conditions that drive the
colors. Post back with more detail about those conditions. HTH Otto
"benmormedical" wrote in message
...
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