Home / Discussions

Report Offensive Message

This could apply to multiple columns
It just tests two but it would be easy to expand to test more columns.

=AND(NOT(ISBLANK($A1)),NOT(ISBLANK(A1)))

The first test uses absolute column reference to test the cell in column A in the row of the cell being formatted. The second tests the cell being formatted.
Posted by N / A
13th Feb