Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to prevent data entry into certain cells if another cell's data
is greater than or equal to 102. For example I don't want a user to enter
data into cell C5 if cell AC5 is greater than or equal to 102.

I created a custom data validation but keep getting stuck on the formula.
 
Change the Allow option to Custom, and add formula of =AC5<=102

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel code, end function? 0
Conditional format if difference in cell values greater than 0.50% 1
data entry validation 1
A data validation question 1
If formula and Data Validation parallely 1
data validation based on cell value 2
= cell above last entered data 8

Back
Top