I need help creating a formula, if possible, that will automatically format the information on one tab, if the same information is already formatted on another tab.
A specific example I would need this for would be:
At 9am, i upload data onto a spreadsheet, on 'sheet 1'. Column A are the accounts, column B are the amounts posted to each account that day. I highlight all cells in column B that match in our system.
At 3pm, i upload the information again, with obviously new data included since the morning run. Could i paste the info into a new tab, 'sheet 2' and create an effective formula that would automatically format column B to highlight all cells with the same account and amount as highlighted earlier that day on 'sheet 1'?
It would save on duplicating work I've already done.
A specific example I would need this for would be:
At 9am, i upload data onto a spreadsheet, on 'sheet 1'. Column A are the accounts, column B are the amounts posted to each account that day. I highlight all cells in column B that match in our system.
At 3pm, i upload the information again, with obviously new data included since the morning run. Could i paste the info into a new tab, 'sheet 2' and create an effective formula that would automatically format column B to highlight all cells with the same account and amount as highlighted earlier that day on 'sheet 1'?
It would save on duplicating work I've already done.
Last edited: