Compare two columns to two other columns

[majaro]

I need to compare the data in 4 columns. Say the columns are A,B,C,D. If all columns are the same leave C and D un-formatted. If A & B do not equal C & D turn C & D interior say light yellow.

[Bob Phillips]

Use conditional formatting with a formula of

=OR(A2<>C2,B2<>D2)

in both C2 and D2

[majaro]

Thanks Sid