I want to compare 2 cells that have VLOOKUP formula and conditional format

[El Salvador]

Hi,

I have created a spreadsheet which has columns A-K populated with info from one source, and columns L-V populated with info from another source. The column headers in A-K are duplicated in L-V.

All of the cells in these columns have VLOOKUP obtaining information from an external source.

What I want to do is COMPARE the two sources and add a conditional format.

For example if the contents of B3 and M3 is the same, leave it. But if it's different turn the cell red.

Is there any way to do this?

 

[kevatarvind]

you can simple use Conditional Format like COL A CELL NOT EQUAL TO COL L CELL


IF YOU NEED MORE HELP REGARDING THAT PLS LET ME Know