Yes, I eventually saw your posting, but not until after my message was sent.
I'm glad we were in agreement.
--
David Biddulph

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

Did you see my subsequent posting? I realised straight after posting that
I had inadvertently copied B6:K6 twice.
2007 behaves the same as 2003 - just slower <bg.
--
Regards
Roger Govier

"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.