You can’t actually count the coloured cells using formulas – but you can
count using the same conditions as you used for the conditional
formatting, e.g. for row 2, assuming your columns start at A.

=COUNTIF(A2:DL2,"0")-COUNTIF(A2:DL2,"100")

then

=COUNTIF(A2:DL2,"100")-COUNTIF(A2:DL2,"200")

etc.


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503701