Thread: Excel Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default Excel Formula

Go to Data--Validation, select Custom and enter a formula like G6 if the
value in G6 is the value which has to be smaller than the value in the cell
whose value you want to restrict.

Dave
--
Brevity is the soul of wit.


"JWC" wrote:

How do I create a formula that would not allow a numeric value to be place in
a cell that is less than a value in another cell? Using Excel 2003 w/SP2.