I have an excel spreadsheet with 95 columns. I want to compare column 1 to column 95 and highlight in column 1 any line item that is missing from column 95, then compare column 2 to column 95 highlighting in column 2 any line item missing from line 95 continuing to lines 94 and 95. Can you provide me with a solution?
You can use conditional format
So If you click on A1 and then select all columns till column CP
and use the formula
=AND(A1<>"", ISERROR(MATCH(A1,$CQ:$CQ,0))) and select the color you would like to see