Blinking Cell

[data808]

Is it possible to have a cell blink when numerical value changes? I would want either the cell or font to blink red whenever the value changes until it reaches 150 or more. Once the value becomes 150 or more, I would like it to flash green. There will be a decimal in there too sometimes, for example, 71.59 or 122.19. So anything 149.99 and under blink red and anything above that blink green. Is this possible? Thank you.

 

[data808]

Change Private Const FLASHING_CELL = "Sheet2!A1" to:
Private Const FLASHING_CELL = "Sheet1!A1"

Ok I just tested it in the actual file that I want the blinking cell in (not a blank workbook) and I am getting an error message:

Run-Time error '1004': Method 'Range' of object '_Global' failed