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)
 
Back
Top