Cell Changes Color Evertime it Changes

[carl]

Is possible to have a cell change color everytime the value changes.

I have a spreadsheet that tracks stock prices. I would like the cells change
from no color to a color every time the prices changes.

[Don Guillett]

You need to give more info.

What changes the value in the cell?
If it already has a color due to a change, what happens when it changes
again?
etc.

--
Don Guillett
SalesAid Software
[email protected]
"carl" <[email protected]> wrote in message
news:[email protected]...
> Is possible to have a cell change color everytime the value changes.
>
> I have a spreadsheet that tracks stock prices. I would like the cells
> change
> from no color to a color every time the prices changes.

[carl]

Thanks Don.

The cell changes value because of a "formula" in the cell (DDE Link).

Not sure what to do if the cell already changed. Open to suggestions.

I am trying to create an effect that the screen should be "flashing" as
pruices are changing.

"Don Guillett" wrote:

> You need to give more info.
>
> What changes the value in the cell?
> If it already has a color due to a change, what happens when it changes
> again?
> etc.
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "carl" <[email protected]> wrote in message
> news:[email protected]...
> > Is possible to have a cell change color everytime the value changes.
> >
> > I have a spreadsheet that tracks stock prices. I would like the cells
> > change
> > from no color to a color every time the prices changes.
>
>
>