conditional formatting for not duplicate rows.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kang - 09 Aug 2007 02:11 GMT

I have A, B columns,
and I want to do conditional-formatting for rows whose A is the same and
B is not the same.
I mean
X 1
Y 2
Z 3
Z 3
Y 1
X 2
because for all rows B column for X have different (1,2), so i want to
highlight them.
on the other hand,
for Z's B column have the same values(3) so I want them to be intact.

Am I clear?

Reply to this Message

Max - 09 Aug 2007 03:14 GMT

One way

Assume data within A1:B100

Select A1:B100 (with A1 active), then apply CF using Formula Is:
=SUMPRODUCT(($A$1:$A$100=$A1)*($B$1:$B$100=$B1))<2
Format to taste, ok out.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I have A, B columns,
> and I want to do conditional-formatting for rows whose A is the same and
[quoted text clipped - 12 lines]
>
> Am I clear?

Reply to this Message

Rate this thread: