Highlighting across multiple sheets
I have a master sheet with data. This data is split into 5 separate sheets on the same excel document, so 6 sheets in total. Is there a way to have excel highlight across the sheets? The goal I’m trying to achieve is that when information is highlighted by hand in sheets 2-6, that the information that matches it in sheet 1 is also highlighted. Thank you for any help!
I have a master sheet with data. This data is split into 5 separate sheets on the same excel document, so 6 sheets in total. Is there a way to have excel highlight across the sheets? The goal I’m trying to achieve is that when information is highlighted by hand in sheets 2-6, that the information that matches it in sheet 1 is also highlighted. Thank you for any help! Read More