Conditional Formatting to compare lists and order

		Microsoft Office Forums > Microsoft Excel > Excel
Conditional Formatting to compare lists and order

FAQ

Thread Tools

Display Modes

07-09-2014, 09:40 AM

gebobs

Windows 7 64bit Conditional Formatting to compare lists and order

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 AM.