D
D Lewis
I have looked all over multiple forums to try and find a forumla or wa
to use conditional formatting to set this up but I cannot fin
anything.
I have data in to seperate ranges, Column A duplicates in each, Column
may or may not change. What I need is when A matches but B changed,
need 1 or both rows to be highlighted.
(I can't figure out how to post a screenshot of the spreadsheet here)
.......... A ............. B
01 .. Account ..... Status
02 .. 100 ............ pending
03 .. 105 ............ rejected
04 .. 136 ............ rejected
05 .. 175 ............ sent
06
07 .. Account ..... Status
08 .. 100 ............ pending
09 .. 105 ............ sent
10 .. 136 ............ rejected
11 .. 175 ............ sent
12
In this example what I would like to see is Row 3 and/or Row
highlighted.
(Cell B3 and/or B9 being highlighted would work as well)
Any help I can get would be greatly appreciated
to use conditional formatting to set this up but I cannot fin
anything.
I have data in to seperate ranges, Column A duplicates in each, Column
may or may not change. What I need is when A matches but B changed,
need 1 or both rows to be highlighted.
(I can't figure out how to post a screenshot of the spreadsheet here)
.......... A ............. B
01 .. Account ..... Status
02 .. 100 ............ pending
03 .. 105 ............ rejected
04 .. 136 ............ rejected
05 .. 175 ............ sent
06
07 .. Account ..... Status
08 .. 100 ............ pending
09 .. 105 ............ sent
10 .. 136 ............ rejected
11 .. 175 ............ sent
12
In this example what I would like to see is Row 3 and/or Row
highlighted.
(Cell B3 and/or B9 being highlighted would work as well)
Any help I can get would be greatly appreciated