Hi All,

I have a range C6 to AK6 where some have x's in them. There are five
groups of x's. R6 to T6 is the smallest group.

I'd like S6 in the group to turn colour if, any cell in C6 to AK6
matches it (has an x), except the cells in it's group (R6 to T6).

Does anyone know how to do this first part?

Then the hard one is the non-contiguous group. It's C6 to E6, plus R6,
U6, and AA6. Yes, this group has four cells which are in other groups,
too.

Does anyone know how to do this part 2?

I thought conditional formating would work, but I'm not very clear on
how the formula part works.

XP and Excel 2003, but has to work on 2002, too. I hope that's enough
info.

Thanks,

Michele