Thread: How to give an error message if a cell value entered is larger than permitted
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How to give an error message if a cell value entered is larger tha
Use Data Validation. See:

http://www.contextures.com/xlDataVal06.html
--
Gary''s Student - gsnu200721


"Colin Hayes" wrote:

HI

In column A I have a row of figures.

In column B , I am entering figures which must be equal to or lower than
those shown in column A , comparing cell-for-cell A1 to B1 , A2 to B2
and so on.

What I need to do is to have a Stop message box pop up when the figure
entered in B is larger then the figure showing in A , asking that the
number be re-entered.

Can someone help?

Thanks.

Reply With QuoteReply With Quote