I have two unrelated dimensions that I want to compare and highlight based on matching text. If a result in column A matches a result in column B, I would like to highlight it in the table.
I have tried this:
=If(If(PType = 'Small', PName) <> Item, yellow())
but this only works if the results show on the same row using.