Pop up reminder based when specific wording is present (VBA or Macro?)
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells.
Is there a simple formula or code that can notify when a cell reads Overdue?
Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data.
I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”.
Any and all help is much appreciated !
I am trying to create a pop up message/reminder/alert when certain projects read “Overdue” in certain cells. Is there a simple formula or code that can notify when a cell reads Overdue? Once I enter dates for my many projects, there are formulas for each project that show when the due date is and whether the project is currently “Not due or Overdue” based on those dates/data. I am looking to have a pop up reminder or Macro of some sort that I can quickly check if any dates are “Overdue”. Any and all help is much appreciated ! Read More