Excel 2007 Conditional Formatting Based on Entire Row Contents

[RP1America]

I have two spreadsheets that contain tabular data. Each row contains task time-tracking information for employees. So each row is one task with cells that contain date, amount of time, task type, notes, etc.

The spreadsheets should be identical, yet I need to verify this. If I open a new workbook and copy/paste both spreadsheet's data into it, can I create conditional formatting that will highlight the entire row if the ENTIRE ROW is a duplicate?

Thanks!
Ryan

 

[SkipVought]

hi,

You cannot reference another sheet in CF.

You need a cell by cell comparison. You could do in a series of heler columns on the sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}