Assuming there's not more than 3 different keys to CF, here's how ..

Select cols A and B (A1 active), then apply CF using "Formula Is"

Cond1: =$A1="Key1"
Format to taste

Cond2: =$A1="Key2"
Format to taste

Cond3: =$A1="Key3"
Format to taste

Ok out

Adapt the 3 keys to suit, viz: Key1, Key2, Key3
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"kang" wrote in message
...
there are two columns.
the first column is the key column, and the second one is the value
column.
I want to conditional-format the rows which is the same key with
different values.
Help me.