Hey, that worked great, thanks.

So what was the flaw in my INDIRECT("G"&ROW()) approach? I tested the
function outside of the condition format and it worked fine.

"Biff" wrote:

Try using Offset.

I don't know what cell you're wanting to format but offset that cell by 0
rows and the number of columns from column G.

For example, if the cell being formatted was A13:

=AND($E13="Y",OFFSET($A13,,6)="",$M13="")

Biff

"andy62" wrote in message
...
I have the following formula as a conditional formatting test:

=AND($E13="Y",INDIRECT("G13")="",$M13="")

The INDIRECT function is testing to see if the cell in column G of the
same
row is blank. I need to use INDIRECT instead of a direct reference
because
the data in column G can get cut/pasted, and I need to hold the reference
stable. But I need to copy this conditional format down 1500 rows, so I
tried to change to INDIRECT("G"&ROW()). But it doesn't quite work,
because
the INDIRECT function tests out as "Volatile" instead of "TRUE"?? Anyone?