Is it possible to change the colour of a cell if the values from both the 'PERSON' and
'ISSUE' columns match up. So because there are now two rows meeting the same criteria,
I want the cell with person in it to change to orange.
I've tried conditional formatting but it seems pretty limited, unless I'm looking at the wrong thing.
Thanks for you help.