I have looked all over multiple forums to try and find a forumla or way to use conditional formatting to set this up but I cannot find anything.
I have data in to seperate ranges, Column A duplicates in each, Column B may or may not change. What I need is when A matches but B changed, I need 1 or both rows to be highlighted.
This is an example of what I have now.
Untitled-2.jpg
This is what I want it to look like after the formula/ formatting
Untitled-1.jpg
In this example what I would like to see is Row 3 and/or Row9 highlighted.
(Cell B3 and/or B9 being highlighted would work as well)
Any help I can get would be greatly appreciated.
Bookmarks