Thread: color with duplicate data in 3 worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
xtrmhyper[_7_] xtrmhyper[_7_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote