Function or formula to return active cell?

[Dan]

I am looking for a way (in a formula or function) to
determine the active cell. I would like the value to be
the active cell every time the worksheet is recalculated.

I want to do some sophisticated conditional formatting,
depending on what cell the user has highlighted.

I do not want to use VB or VB script - I do not want
macros or code in the worksheet.

Thanks in advance.

--Dan

 

[Tim Otero]

You cannot determine the active cell without code

tim

 

[Tom Ogilvy]

=CELL("Address")

will give you the active cell at the time of each recalculate.

 

[Tim Otero]

Thanks Tom,

I guess I didn't completely understand his question. I thought he wanted to
do something else. Reading it now, I see your answer works for him.

Thanks again,

tim