Hi,
I have the below macro that highlights any collection date that is 5 days old. I have two fields one called collection (a) and one called delivered (b). when an item is collected a date gets entered, if the item that was collected isn't delivered within 5 days the field highlights. The problem that I'm having is that if the item is delivered after I run the macro the cells stay highlighted! If I clear the fill and re-run the macro if works fine.
Any suggestions would be very welcome?
Please Login or Register to view this content.
Bookmarks