Thanks for the the suggestion but the formula seems to always return true
even when the active cell is no longer in the row with the fromula.
I need to compare the row that contains the formula with the row of the
active cell.
If they are the same then display "X" else display nothing.


"David Billigmeier" wrote:

Use the CELL() function, CELL("row") will always return the row of the active
cell:

=IF(ROW()=CELL("row"),"X")

Note this will continue to populate if the active cell is in the same row on
another tab as well.
--
Regards,
Dave


"Dave" wrote:

Is there a function that returns the row, column or address of the active cell?
I'd like to build a formula in a column that displays a character if the
active cell is in that row, such as:
=IF(ROW()=ROW(ActiveCell),"X")
Thanks.