Quote:
Originally Posted by Catalin.B
you can simply use conditional formatting to do this. Select the two columns, Open conditional formatting , highlight cells for double data, no matter if data is numeric or text. This will work even if you continue to add data to those columns, if you add a value that already added, it will be highlighted automatically.
|
Thanks Catlin. I can't quite follow how to do this. I am trying to compare two columns in a spreadsheet to move rows that meet the criteria to another spreadsheet using the advanced filter. I know I can change the font characteristics/etc using conditional formatting, but how would I use that in an advanced filter criteria?
07-26-2011, 04:47 AM
Similar Threads
How to compare 2 columns with other two columns in EXECL 2007?
Windows XP 
Office 2007
Threaded Mode