I have a spread sheet where column G contains dates projects were completed. If the project hasn't been completed the cell should be blank.
What I would like to do is turn the entire row gray (15% gray) when a date is entered into the cell in column G. I would also like an alert message to appear reminding them to submit their satisfaction statement.
I have tried using conditional formatting setting the cell condition to not equal to blank, but that seems to turn the cell gray even if I haven't entered a date, and it leaves it gray if I delete the date.
I have no idea on the alert message, so any help is most appreciated.
Thanks
What I would like to do is turn the entire row gray (15% gray) when a date is entered into the cell in column G. I would also like an alert message to appear reminding them to submit their satisfaction statement.
I have tried using conditional formatting setting the cell condition to not equal to blank, but that seems to turn the cell gray even if I haven't entered a date, and it leaves it gray if I delete the date.
I have no idea on the alert message, so any help is most appreciated.
Thanks