Hello! I'm getting very frustrated with this
I need to highlight changes in a table in sheet 1 if they are different than the table in sheet 2. Sheet 1's table live updates numbers and I want to show where new changes appear.
If I have this table in Sheet 1:
# Name Code 1 Yellow PB-4 1 Yellow PB-5 1 Yellow PB-6 2 Red PB-08 3 Orange PB-11
And this table in Sheet 2:
# Name Code 1 Yellow PB-4 2 Red PB-08 3 Orange PB-11
I need PB-5 and PB-6 to be highlighted in the Yellow section, where they've been added.
The problem I'm encountering is that if PB-05 is in the BLUE section in both tables, I would only want it to be highlighted where I added it to the yellow section - so the # and Name attached to the code also need to be accounted for in the formula.
Can you help me before I pull all my hair out?
Thank you!
Meggo
Bookmarks