Can you display a text message if a cell does not exceed a pre-detemined value?

Question

With excel, I want to display a text message if a value in a cell does not exceed a per-determined value, For example, if a value needs to be greater than 499, issue a message that says value must be at least 500 when the 499 or less value is entered into that cell.

Answer 1

Hi,

Please check whether the following solution is helpful:

You may use Data Validation to restrict the User from inputting a value less than 500.

1. Select the cell OR cells where You want the User to input value greater than or equal to 500 (or any other number as per Your requirement) > go to **** Data tab > click on Data Validation > Select Whole number in the 1st drop-down > Select greater than or equal to in the 2nd drop-down > in the next field, input 500 (or any other number as per Your requirement).

2. Under **** Error Alert tab > You may customize the message that will appear if the User inputs value less than 500.

Message pops-up if the User inputs value less than 500.

The above solution restricts the User from inputting a value less than 500.

However, if You only wish to inform the User and not restrict the User, You may do the following:

Under **** Error Alert tab > You may choose Warning OR Information > Warning OR Information warn OR inform the User but allows the User to input a value less than 500 if the User still wishes to.

Warning: Above solution can be by-passed if the User pastes 499 or a lesser value on the cell where Data Validation was applied.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 2

Re: message to be displayed depending on cell value

Yes that can be done, but it requires VBA code in the worksheet module.
It is fairly simple to write.

'---
Nothing Left to Lose