Forum Discussion
Conditional formatting formula evaluation is inconsistent
I have the following conditional formatting formulas: 1. INDIRECT(ADDRESS(ROW(), COLUMN() - 5))<>INDIRECT(ADDRESS(ROW(), COLUMN())) 2. AND(TRUE,TRUE) 3. AND(INDIRECT(ADDRESS(ROW(), COLUMN() - 5...
It is not recommended to use AND and OR in conditional formatting, use * and + instead. Sometimes AND/OR don't work, looks like your case.
Conditional formatting rule formula could be
=( INDIRECT(ADDRESS(ROW(), COLUMN() - 5) ) <> INDIRECT( ADDRESS(ROW(), COLUMN()) ) )*(INDIRECT(ADDRESS(ROW(), COLUMN() - 5))<>INDIRECT(ADDRESS(ROW(), COLUMN() )) )when it works