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...
nathlrowe Can't explain why the combination of AND, INDIRECT and ADDRESS doesn't work in conditional formatting. You can use them together in worksheet formulas, though your first and third one would need to be entered in a cell of their own, for instance in the next cell on the same row, referencing COL()-6 and COL()-1. Otherwise you get a circular reference.
Anyhow, you can use another rule to achieve what I believe you have in mind. See attached.
If that's not it, please clarify your intentions with some screenshots and/or a link to your file on OneDrive, Dropbox or similar.