Question description:
This user has given permission to use the problem statement for this
blog.
Am trying to set a numerical limit in a cell, that if data is entered into cell that exceeds the limit, the cell is flagged or a warning message appears?
Solved by M. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/06/2018 - 01:56
hello..??
User
06/06/2018 - 01:56
?
Excelchat Expert
06/06/2018 - 01:57
do you want to set limit on what you can input into cell..??
User
06/06/2018 - 01:58
no, i want to be notified when the limit is being exceeded
Excelchat Expert
06/06/2018 - 01:58
ok.. no problem..
Excelchat Expert
06/06/2018 - 01:58
do you have any examples.. ??
User
06/06/2018 - 01:59
0.004 & 0.004 have exceeded the limit of 0.003
Excelchat Expert
06/06/2018 - 01:59
ok... what limit do you want to setup for warning sign..
User
06/06/2018 - 01:59
lets say 0.003 here
Excelchat Expert
06/06/2018 - 01:59
0.003 will be upper limit for warning...??
User
06/06/2018 - 02:00
yep
Excelchat Expert
06/06/2018 - 02:00
are you going to use this in excel or google sheet..?
User
06/06/2018 - 02:00
excel
Excelchat Expert
06/06/2018 - 02:01
it's be little bit different..
Excelchat Expert
06/06/2018 - 02:01
i will show in google sheet first.. and upload excel sheet for your review..
Excelchat Expert
06/06/2018 - 02:01
first you need to select area ..
User
06/06/2018 - 02:01
ok
Excelchat Expert
06/06/2018 - 02:02
than select menu Data>Data Validation..
Excelchat Expert
06/06/2018 - 02:03
change criteria.. like what i did..
Excelchat Expert
06/06/2018 - 02:03
now it will show warning message when you input number bigger than 0.03
User
06/06/2018 - 02:04
thank you for your help, much appreciated
Excelchat Expert
06/06/2018 - 02:04
hold on..
Excelchat Expert
06/06/2018 - 02:05
you can try in google sheet or excel will be the same..
User
06/06/2018 - 02:06
thats great
Excelchat Expert
06/06/2018 - 02:06
in excel you need check option tap for Error Alert.
Excelchat Expert
06/06/2018 - 02:06
there is option for Warning and Stop..
Excelchat Expert
06/06/2018 - 02:07
You only need warning, so you need choose Warning..
User
06/06/2018 - 02:08
cheers
Excelchat Expert
06/06/2018 - 02:08
do you want excel file..for this..??
User
06/06/2018 - 02:09
yes pls
Excelchat Expert
06/06/2018 - 02:10
[Uploaded an Excel file]
Excelchat Expert
06/06/2018 - 02:10
check yellow colored cell..
Excelchat Expert
06/06/2018 - 02:10
try input some numbers..
Excelchat Expert
06/06/2018 - 02:11
select yellow colored cell.. and click data>data validation menu to see how validation has been setup..
Excelchat Expert
06/06/2018 - 02:13
[Uploaded an Excel file]
Excelchat Expert
06/06/2018 - 02:13
i changed little bit of validation formula..
Excelchat Expert
06/06/2018 - 02:13
now you can change limit of validation
Excelchat Expert
06/06/2018 - 02:14
You can use any of them...
Excelchat Expert
06/06/2018 - 02:15
is there any other questions for me...?
User
06/06/2018 - 02:15
ciao :)
Excelchat Expert
06/06/2018 - 02:16
ok.. thank you for the session..
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.