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.