I have a worksheet with many dependant dropdowns that are liable to having invalid data if the initial drop down is altered. I would like a macro that would automatically run the "circle invalid data" command everytime a new value is entered in a cell within a specified range (D8:T800)
It sounds fairly straightforward but i am not sure how to do this.
Question - as this macro will run every single time a cell is amended would this macro slow down the worksheet?
Many thanks,
Dan
Bookmarks