Conditional formatting

[MFT]

Dears, I need a "conditional formatting" to get highlighted if all the information are matching in all 3 tables like in the sheet.

 

[James006]

Hi,

Are the three tables located in the same worksheet ?

 

[MFT]

Hi James,

Yes the tables are in the same worksheet only.

 

[kvsrinivasamurthy]

B3=P-8493
Select B3:L8.
Formula for CF
=AND($B3=$G3,$B3=$L3)

 

[James006]

OK ...
So you could test following

=AND(AND(A2=F2,F2=K2),AND(B2=G2,G2=L2),AND(C2=H2,H2=M2),AND(D2=I2,I2=N2))

 

[MFT]

OK ...
So you could test following

=AND(AND(A2=F2,F2=K2),AND(B2=G2,G2=L2),AND(C2=H2,H2=M2),AND(D2=I2,I2=N2))

Thanks James, It is working

 

[MFT]

B3=P-8493
Select B3:L8.
Formula for CF
=AND($B3=$G3,$B3=$L3)

Thanks for the formula, Srinivasamurthy

 

[James006]

Thanks James, It is working

Glad you could fix your problem