Share via

Alert in Excel

Anonymous
2017-08-10T00:05:12+00:00

I have a spreadsheet with a list of names, check boxes and times. I would like it to alert me when a particular cell is blank and the time has been reached. So if a person was supposed to contact us by 7.30am but the cell for that day is still empty I want an alert to show that person hasn't called yet. I realise this is probably impossible but you don't get anywhere if you don't ask the question.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2017-08-11T16:14:17+00:00

Well, you can use a formula like

  =IF(A1<TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW())),"Alert!","")

and/or a conditional formatting to color the cell.

But Excel did not auto-update, means did not recalculate the formulas automatically.

So you have to press F9 from time to time to force the calculation.

Most users use that and use the conditional formatting to have a pre-alert, means color the cell yellow e.g. 15 minutes before.

Andreas.

Was this answer helpful?

0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest