Live cell triggers another cell

[frankie666]

Hi all,

I am unable to find the solution to the following problem: In "A1" I have a stock price live (from yahoo - moving continuously) and I want to put an "X" in "B1" as soon as "A1" (the stock price) goes below a certain value (10 for example). Then even if the stock price move back above 10, I still wants to keep an "X" in "B1".... Any idea? Thanks in advance for your help.

Rgds, Frankie

 

[Andrew Poulsom]

Welcome to MrExcel.

That would require a circular reference:

=IF(A1<10,"X",IF(B1="X",B1,""))