S
Simon
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.
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.