color with duplicate data in 3 worksheet
 

in 1 sheet formula to color duplicate data is:
FormatCondinal formatting
then select formula is
type this:
=COUNTIF(K:K,K1)<1

then select the color and type of fonts

how about if you have 3 worksheet?


--
xtrmhyper
------------------------------------------------------------------------
xtrmhyper's Profile: http://www.excelforum.com/member.php...o&userid=23851
View this thread: http://www.excelforum.com/showthread...hreadid=486156