Not sure why you have the (1=1) term in there, or indeed why you have
got INDIRECT(ADDRESS(ROW(),COLUMN())) - why not just use a cell
reference here?

Hope this helps.

Pete

On May 14, 3:25*pm, Hamish wrote:
The formula I wish to use for conditional formatting is:
=AND((MOD(COLUMN(),4)=1),(INDIRECT(ADDRESS(ROW(),C OLUMN()))=MIN($E17,$I17,$*M17,$Q17,$U17)))

If I use:
=INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN($E17,$I17,$ M17,$Q17,$U17)
That works correctly. The highest value in the row is highlighted.

If I use:
=AND((MOD(COLUMN(),4)=1),(1=1))
That works correctly. The first and every 5th column is highlighted.

However, if I use:
=AND((1=1),(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN( $E17,$I17,$M17,$Q17,$U17)*))
This does not work correctly. Nothing is highlighted.