Thread: Cond Format & helper-cell based "duplicate rec" tricked by content
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Cond Format & helper-cell based "duplicate rec" tricked by content

Hi, as far as I know, you can not use an IF function in CF.
Try:

=COUNTIF(Range1, B5)1

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=494092

Reply With QuoteReply With Quote