ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   alarm on a date cell (https://www.excelbanter.com/excel-worksheet-functions/189811-alarm-date-cell.html)

devonguy

alarm on a date cell
 
I have a series of cells that I would like to trigger a pop up alarm to show
a due date in that cell, I,m currently using an adjacent cell with the
function =IF(A1<=TODAY(),"OVERDUE","") then conditional formatting to turn
the cell red, as the workbook contains many sheets all of which I would have
to scan to observe any alarms I would love to have a pop up alarm when I
opened the workbook, thanks for your help.


All times are GMT +1. The time now is 12:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com