If you provide the formula which drives the conditional formatting of the
COST column I can probably help.

"SMac" wrote in message
...
I have a worksheet that has over 3,000 rows and I have a COST column that
is
shaded when the DATE column is below a certain date (which I used
conditional
formating).

Now what I would like to do is added together all the shaded COST fields -
what do I need to write to accomplish this?

Thanks!
Stacey