Data Validation
 

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.

Data Validation
 

Change the Allow option to Custom, and add formula of =AC5<=102

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rmorg" wrote in message
...
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.