One solution would require VBA to analyse the font in each cell.

Another would be to use the same critera in a sumif funtion that is
being used in the Cond. Format. e.g. if your Bold CF is based on
numbers =2 and <4 then:

=SUMIF(J3:J6,"=2")-SUMIF(J3:J6,"=4") would work, returning the total
of all values =2 and <4.

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=466036