Conditional Formatting Between Two Worksheets
I have 2 spreadsheets of names (~2500 and ~1800) and a bunch of corresponding data continuing down the row. both are structured this same way:
Row1: LAST, FIRST, data1, data2, data3, etc...
How can I construct a formula so it will "check" the larger sheet for duplicate names (a row containing exactly the same FIRST and LAST names), & then change the cells' fill colors in the smaller sheet from white to red for all rows meeting this condition
One other piece of information which might be important:
For these rows containing duplicate first & last names, the entire row is not a duplicate entry; only the names will match (columns A & B)... While the other columns down the row will have different values between sheet1 & sheet2. Not sure if this changes anything.... Thanks
Last edited by liiv17; February 18th, 2007 at 04:56.
Video Tutorials / Excel Dashboards Reports