Maybe you could use the following cond. format for col c
cell value is
not equal to
=C1-(SUMIF($A$1:$A$8,A1,$B$1:$B$8)-SUMIF($A$1:$A$8,A1,$C$1:$C$8))


- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584