i have six columns in excel. A B C D E F.

i need to compare A with D, B with E and C with F(row by row)..and see if all three match.

is there any formula to highlight the rows(by giving it different color, or presenting in BOLD or any other mechanism) A matches with D, B matches with E and C matches with F? plz help if anyone has any idea on excel formulas....