I was wondering if there is a way to use conditional formatting to highlight a cell value based on which column it gets the information from. I have zone information that is stored in 2 columns (Source A and Source B). The two columns have to be kept separate. I have another column (the one that I'm trying to apply the conditional formatting on), which uses this formula:
=IF(OR(A2="",A2 = "UNIDF"),B2,A2)
I want to use conditional formatting to highlight any time the information was returned from Source B. Is this possible?