Hello All,
Not sure if possible but would be helpful if it is.
I need conditional formatting to check if cells contain two substrings together.
for example the following combinations are not allowed together:
(RFL & ROX), (RCM & RFW), (ELI & RNG)
A1| RFL.ROX.CAO / BLABLA
A2| BLABL - THIS AND THAT
A3| ELI OHG/CM/15A | RFL
A4| IND/CM/15A & RCM/RFL.RFW
Cells A1, A2 and A4 should turn red because each of them contains a combination of 2 values that are not allowed together.
It is unfortunately not allowed to use VBA or use helper columns in the document I need it for
Any ideas?
Bookmarks