How can I detect a change in cell value from a series of an excel sheet and then Highlight the change through a script
2 views (last 30 days)
Show older comments
I have a large excel sheet which consists of strings and Integers. I have read the sheet through 'readtable' but How can I compare a cell value(column wise) from it's previous cell value and Highlight the cell by a particular colour?
Any Help would be appreciated.
2 Comments
dpb
on 1 Jul 2021
Look at diff() to find differences of given variable -- remember the output array is one less in length than the input array in finding the actual array location.
As for changing formatting inside Excel, that's a job that has to be done with ActiveX/COM
There are sample routines that have been posted in the past although I didn't think to save a link -- if somebody else doesn't get there first, I'll try to come back and attach the utility routines code.
Undoubtedly is something at FEX, too,
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!