Hi,
I'm looking to conditionally format column AX7 based on whether column AU7 and AX7 contain any of the values of a list of values eg "A", "B", "C", "D".
So, I would like column AX7 to light up red if columns AU7 and AX7 contain any of the aforementioned values. To give you an idea of what I am trying to accomplish, the cells already light up amber if any of those values have been entered once, which is pretty simple to do.
I would like to do the same for column BA7 (based on columns AX7 and BA7).
Is this possible?
Bookmarks