I'm looking for a macro to highlight cells based off of the highlighted cells of another sheet.
In this specific case the numbers in columns in B and H in the first tab may be highlighted in maroon or red.
If they are, I need a macro to change the corresponding numbers in tab 2 to the same highlighted shade.
There may be more than one of the same number throughout the spreadsheet, but only one number and corresponding description exist in the spreadsheet.
The descriptions are adjacent to the numbers in columns C and I.
Hope this makes sense. I've attached an example workbook. Tab 1 is the original template, Tab two will be the spreadsheet where the highlights need to be changed. Tab three is what I would like the final output to look like after the macro is run.
10% Prepayment sent