Forum Discussion
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...
you could do a simple VBA/Macro but I have been leaning away from macros because they are disabled by default and don't work in the online version so unless this is ONLY for personal use and a macro is the only way, I tend to avoid.
In this case I think you could easily make a formula in a cell to output "OVERDUE FOUND" or "no overdue items" and then use conditional formatting to make is stand out in red if it says overdue found. The formula might be simple like if the cells that might say "Overdue" are in column D then:
=IF(ISNUBMER(XMATCH("Overdue",D:D)),"OVERDUE FOUND","no overdue items")
In this case I think you could easily make a formula in a cell to output "OVERDUE FOUND" or "no overdue items" and then use conditional formatting to make is stand out in red if it says overdue found. The formula might be simple like if the cells that might say "Overdue" are in column D then:
=IF(ISNUBMER(XMATCH("Overdue",D:D)),"OVERDUE FOUND","no overdue items")
I appreciate your response but I have a rather large set of data and it would be much easier to have a pop up that can tell me where there is the Overdue cell - vs. having to scroll and "un-hide" cells/columns to search for them - even though they are highlighted RED and do stand out - it would still take me quite sometime to search the entire sheet/workbook for Overdue items -
but thank you so much for your input.
but thank you so much for your input.
baugustadt Well you can add the address of where the Overdue item was found. In the attached I added that formula and also the corresponding macro. The advantage of the macro is it will also select that first found item (and scroll to it)