Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a spreadsheet with two sheets named 'RQ' and 'HL'.
I have three columns called 'user name', 'record number' and 'date' in both sheets. I need to check whether each row (based on the data in the three columns) in 'HL' is in the sheet 'RQ' and if it is not, then colour the row is 'HL'. The data in 'HL' is dynamic, so the ammount of rows vary. Example 'HL' c12345 555 13/01/04 c54321 123 13/01/04 c67890 7458 13/01/04 'RQ' c12345 555 13/01/04 c67890 7458 13/01/04 Result The second row in 'HL' would be coloured. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing Across Sheets | Excel Discussion (Misc queries) | |||
Comparing columns in sheets | Excel Discussion (Misc queries) | |||
Comparing multiple columns in two sheets | Excel Worksheet Functions | |||
Comparing columns iin 2 sheets to generate one | Excel Worksheet Functions | |||
comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) |