Hi

It does work in XL2007.
Did you try selecting all the cells first as per my previous posting?

Alternatively, having set it up for one cell, Copy that cell, then Paste
SpecialFormatting to the other cells.

If you can't get it to work, send me your file and I will set it up for you.
To mail direct use
roger at technology4u dot co dot uk
Do the obvious with at and dots.

--
Regards
Roger Govier



"tsum" wrote in message
...
I'll be a little more explicit. I have a spreadsheet used to schedule
duties
of students in various rooms. It is very easy to double schedule someone.
I
had this working in Office 2003 using COUNTIF($B6:$K6,B6)1 which if true
would change the fill color notifying me of the duplicate entry. I was
able
to copy downward and across so that the cell in the row below would
contain
the conditional formatting formula COUNTIF($B7:$K7,B7) and the cell in
same
row but in the next column would contain the formula
COUNTIF($B6:$K6,C6)1.
Now when I copy the formatting the relative part of the formula does not
increment at all.

Also I have just discovered that I cannot make this particular formula
work
in Excel 2007 regardless even with manual entry. Argh!

If I highlight the row section over which I want to check for duplicates
and
use the new duplicate values rules all works well. I can even copy this
formatting to one other row at a time and have it applied to the correct
range. However - If I try to copy it to multipe rows, the search range is
altered to include the group of rows. As each row represents a particular
time slot, I want the applicable range to ONLY be in the same row.

This may be a 'nut in the chair' problem and I have spent some time on it
as
getting it working will ultimately save me more time but I am about to
give
up.

"Roger Govier" wrote:

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

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