Conditional Formatting to compare lists and order

SarahBear · #1 07-09-2014, 08:13 AM

I figured it out!

Okay, you just highlight both lists, go into conditional formatting, new rule, "use a formula to determine which cells to format", then enter in the formula "=$A1<>$B1", set your formating however you want it to show the values that don't match, and hit ok.

gebobs · #2 07-09-2014, 09:40 AM

Quote:

Originally Posted by SarahBear

I figured it out!
Okay, you just highlight both lists, go into conditional formatting, new rule, "use a formula to determine which cells to format", then enter in the formula "=$A1<>$B1", set your formating however you want it to show the values that don't match, and hit ok.

Lovely! I hadn't thought of that. Well done! That's what I'll do from now on.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Conditional Formatting	jdc15371	Excel	2	06-26-2014 06:34 AM
Compare content of two ranges INCLUDING FORMATTING	delasson	Word VBA	3	12-10-2012 03:54 AM
conditional formatting	otuatail	Excel	1	06-06-2012 05:07 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM