Want to colour all rows in sheet 1 yellow, which match the following criteria:
The cell in column B should be included in Column F in Sheet 2.
Column B in sheet 1 contains the account for the line item. While Column F in sheet 2 match specific account.
The cell in column B should be included in Column F in Sheet 2.
Column B in sheet 1 contains the account for the line item. While Column F in sheet 2 match specific account.