Hi!
Time to ask for help:
Empty Apple Blue Empty Banana Green Empty Pear Pink
I'm trying to make the conditional formatting color the text in the triggering cells of column 1 based on the words in the same row of column 2 and 3. If the user typed "Apple" in A1 nothing happens but if the user also types "Blue" in A2 or A3, the text of both these cells would turn red because both Apple and Blue are on the same row in the table. The table I'm working on contains over 100 rows so it would be painful to have to format every cell in column 1 based on every possible input scenario =)
Any ideas? Can excel check the entire column 2 and match by row in column 3 and only format the triggering cells of column 1?
Best,
Bookmarks