I have a list sorted by Name. There is Conditional Formatting so that each line is alternately highlighted, and if a line contains a new/next Name in the sorted list, that line’s text is also bold with a line above (to show a new section starts).
When the formula has Indirect and Address reference it does not work correctly inside the Conditional Formatting, although it does result true/false correctly as a formula in a cell.
When the formula has a Direct reference it formats correctly, and results the same true/false as a formula in a cell (and has the same results as the Indirect and Address reference formula in a cell).
Any suggestions how to fix this would be appreciated.
Bookmarks