Hi
Here is a tough one.
A2:N10 performs calculations on DYNAMIC A20:H32. Dynamic because it may contain variable rows, it always starts on A20 though.
What we ask is to highlight row or rows that do not match any of the calculations in A2:N10, in this case row 21.
This probably needs 2 VBA macros that are sheet specific since similar data and calculations are in sheet 3 (not included here).
One for sheet 1 taking into account ONLY calculations done in A2:N10 and NOT anywhere else in the sheet, and adressing data A20:H...
and
One for sheet 3 taking into account ONLY calculations done in A2:N12 and NOT anywhere else in the sheet, and adressing data A20:H...
Thanks
Bookmarks