Changing a cells format based on another cell and staying in that format

[OldSwimmer1650]

I want to change cell's A1 format when cell B1 exceeds a value of 100.
I want to keep that new format for cell A1 even if cell B1 changes and goes below 100. So, once cell B1 hits a value of 100 or greater the cell A1 format changes and stays no matter what cell B1 does.

[6StringJazzer]

If you want A1 to change format when B1 exceeds 100, then keep that format even if B1 goes back below 100, you will need VBA.

What data is in A1, what is the format, and what do you want to change it to?

[OldSwimmer1650]

A1 is a stock price.
A1 is updated every 30sec by a macro that refreshes stock data.
When A1 goes above 100 I want to change the text color and background color and leave it in the new text color and background color even if the stock price goes below 100. This way I know the value exceeded 100 at some point.

[6StringJazzer]

Can you attach a sample file (see yellow banner at the top of the page)? If not then please show your macro and describe exactly where all the data is.

[OldSwimmer1650]

Yes, give me a little time to build an example worksheet.

[OldSwimmer1650]

Here you go...

[achammar]

Just put this in the worksheets change event:

Please Login or Register  to view this content.

You'll need to set the format of the cell how you want it. This just changes the font color to red.