If you have CF, what is the condition?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"jennerifw" wrote
in message ...

I've tried that and it didn't work.

I have a static number in the cells of colum A. If colum B has a date,
then the number in colum A turns blue. Now I want to add all of the
blue numbers at the bottom of colum A. I've tried SUMIF, using the
same criteria as the conditional formating, and I got an error. Any
other ideas?


--
jennerifw
------------------------------------------------------------------------
jennerifw's Profile:
http://www.excelforum.com/member.php...o&userid=26071
View this thread: http://www.excelforum.com/showthread...hreadid=394409