Re: Conditional formatting, Highlighting of row A to row F when of active cell
Thanks littleiit. But when I run the code, there would be a msgbox "the due date" before my msgbox "Gentle reminder" could be displayed. Can that msgbox be removed?
Another issue would be, I forget there's public holidays. I researched online, there is a need to key in the individual dates or alternative would be country' s holidays? Something like =WORKDAY(A10,-7).