Good morning everyone I hope you're all well.
I wonder if anyone can help me out.
I've been working on a dashboard and I would like to make a few tweaks.
One thing I'm looking to do is highlight new data when it appears.
So my set up is this:
I have created a report that scrapes data from a web based service.
I then have a worksheet alongside this that transfers data from that sheet using VLOOKUP as part of my function I use IF(LEN(VLOOKUP in order to leave any cells that don't have a date left blank.
I have the report set to refresh on opening and what I would like to do is have it set up so that when a new date is pulled into the report and then transffered over to my worksheet. This bit I've done and is working perfectly however, the thing I would like to do would be to highlight any new dates that have been transferred into my worksheet. I was thinking using the IF function in conditional formatting but won't that just highlight all cells with dates in?
Another thing I would like is for the newly highlighted cells to stop being highlight after the next web scrape which is generally 24 hours later.
I hope I have explained this but if you need any further info just give me a shout.
Thanks for your time everyone.
Bookmarks