I dont want to link it to an event, i would ideally like it to check each time the document is opened.. is that possible?
Originally posted by johnccc
Try looking at Conditional Formatting in the Help system and playing around with that for your Highlighting problem.
ps: Excell is Event Driven. Thus an event must occur to trigger your email. What event would you like to link it to? This will give people a better stab at posting you a reply.
Video Tutorials / Excel Dashboards Reports