Hi

Sorry, formula was meant to be
=COUNTIF($B6:$K6,B6)1

--
Regards
Roger Govier



"tsum" wrote in message
...
An example is best: I want to be able to test b6 through k6 for duplicate
values and highlight the duplicates. Then I want to test b7 through k7
for
duplicate values and highlight the duplicates. ...etc. Doing each of
these
ranges one at a time is easy. But I have lot of them. I would like to
use
something like $b6 through $k6 and copy to the subsequent rows. The
relative
reference (6) does not increment when copied to more than one row at a
time.
I used to do this in 2003 but have been unable to make it work in 2007.