G
Guest
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?
=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?