Conditional Formatting with Indirect-Address Referance

[SamsamF]

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.

[DonkeyOte]

SamsamF - first could you outline why you need the INDIRECT references ?

The issue is down to use of ROW within ADDRESS, if you revert to ROWS(A$1:A5) rather than ROW you should find it would work (ROW returns Array whereas ROWS does not)

R1C1 notation would also work and syntax wise is a little more succinct:

Please Login or Register  to view this content.

use of EVEN requires Analysis ToolPak - you could revert to MOD for non-ATP dependant version of the same.

To reiterate though I see no reason for use of INDIRECT at this point given the info we have.