alarm on a date cell

D

devonguy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

alarm on a date cell? 2
Alarm 2 2
Alarm function, disable sound if data is erased 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Can i set a cell to alarm if a date isnt enterd before a set date 4
Cobditional Formatting Rows based on dates in action plan. 0
can alarm be coded into a cell "x" hours before date's reached ? 1
How to set up alarm for cell has entry as date when it expires? 1

Top