highlight dynamic cells when they tick in excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

ricuelo

Thread Starter
Joined
Jan 10, 2009
Messages
37
Hello,
I have a large spreadsheet that has dynamic cells being fed by a pricing engine. I need to monitor when a price changes. How can i make the cell highlight everytime a price ticks so that i can immediately see the change.

regards,
 

etaf

Wayne
Moderator
Joined
Oct 2, 2003
Messages
65,454
can you upload a dummy set of data
what do you mean by
price ticks

have a look at conditional formatting
 

ricuelo

Thread Starter
Joined
Jan 10, 2009
Messages
37
i can't upload a set up dummy data b/c it will just look like a list of prices. in my actual spreadsheet the prices change (tick) on a minute by minute or even second by second basis. there are so many rows that when a price changes it is not obvious to me. i need the cells to flash or highlight when there is a change ( a price ticking) in that cell.

the spreadsheet is being fed so that the prices change automatically, fyi.

regards
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top