COMPARING SETS OF DATA AND HIGHLIGHT DIFFERENCES

[Eddie G.]

I want to compare numbers in A1:E100 to a supposedly same set of data in F1:K1 and highlight any in the F1:K1 set that are different. In other words, A1 should be the value as F1, A2 should be the same as F2 etc. Can this be done?

Eddie G.

 

[lenze]

Select the second range and use Conditional Formatting Cell Value Doe NOT equal A1

 

[IML]

how can be supposedly the same data set when they are diffent sizes?