I think Excel is doing something weird here.
I'm trying to conditionally format a cell based on the cells around it.
There might be a better way to do this but this is what I have done.
I'll just show some trials of formatting conditions I've done.

This works.
=AND(NOT(1<0),TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE)

This works.
=INDIRECT(ADDRESS(ROW(),COLUMN()+1))>0

This doesn't work!
=AND(INDIRECT(ADDRESS(ROW(),COLUMN()+1))>0,TRUE)
It seems that any time I try to use INDIRECT and a logic function in the same condition the formatting is just ignored. I've tried many variations (not(OR) statements etc) but can't seem to sort it out.
I can't seem to find any info on this problem which suggests I'm solving the problem in a weird way.

Any comments or suggestions?
Thanks,
Mike