Message box if condition is met

Hamza Oza

New Member
Joined
Nov 16, 2020
Messages
12
Office Version
  1. 365
Platform
  1. Windows
Hi all,

I just need a simple message box that displays a certain text when cell A5>1. So cell A5 is the sum of A1:A4 and when the sum is greater than nil, I want it to display an error message.
I also need it to reset after the message box (Meaning it must display the error message every time the A5>1 so that the error persists until A5<1)

Any assistance will be highly appreciated.
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

Zot

Active Member
Joined
Nov 26, 2020
Messages
316
Office Version
  1. 2016
Platform
  1. Windows
The range A1:A4 has values that changes from time to time?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,138
Messages
5,570,378
Members
412,321
Latest member
Yusuf_A
Top