Are you trying to highlight only the first of a duplicate pair, Roger?

If you want to highlight both instances, then perhaps something like
=COUNTIF($B6:$K6,B6:K6)1, or just =COUNTIF($B6:$K6,B6)1 ?

[Or does 2007 behave differently in this respect from 2003?]
--
David Biddulph

"Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message
...
Hi

Mark the range you want to apply the CF.
Home tabStylesConditional FormattingNew ruleUse formula to determine
which cells to formatformula=COUNTIF(B6:K6,B6:K6)1

"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.