COMPARING SETS OF DATA AND HIGHLIGHT DIFFERENCES

Eddie G. · Apr 26th, 2002, 11:56 AM

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 · Apr 26th, 2002, 12:01 PM

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

IML · Apr 26th, 2002, 12:02 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 11:56 AM	#1
Eddie G. Board Regular Join Date: Feb 2002 Location: OKC Posts: 98	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.

Apr 26th, 2002, 12:01 PM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Select the second range and use Conditional Formatting Cell Value Doe NOT equal A1

Apr 26th, 2002, 12:02 PM	#3
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	how can be supposedly the same data set when they are diffent sizes?