as i deal with spreadsheets where the data constantly changes, i need a help with VBA solution to highlight any cell that changes meaning if increases value then green and if decreases values then red. just to blink.
I found commercial Add-In, but it requires administrative password to install and in our office environment we have domain user that cannot install exe files, besides corporate does not allow third part commercial softwares. so only VBA works for me.
A brief description of Spheresoft Highlighter from the net is below, i do not need all the sophistications, all I need two colours, and time interval 2 seconds for blinks.
Real-time highlighting is now available for users of Microsoft Excel. The Spheresoft Highlighter lets users specify that cells in their spreadsheets automatically highlight when values change in real-time.
The Highlighter is very useful for financial professionals who incorporate real-time market data feeds. Also is useful for anyone who creates complex spreadsheet models and wants to see what the changes in input can affect.
· Highlighter works on cells that change as a result of real-time DDE links, OLE automation, calculations, or direct user input
· Highlights can flash/blink for a specified time, or stay colored until the spreadsheet changes again or are cleared by the user
· Separate highlight colors for up-ticks and down-ticks
· User-customization of highlight colors and the length of the highlight