View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Mary Ann
 
Posts: n/a
Default Data Validation - Custom

Works fab - thank you. I had forgotten to include the G1 !!

"Ron Coderre" wrote:

Try this:
With G1 as the active cell....
DataData Validation
Allow: Custom
Formula: =G1<=(E1+50)


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Mary Ann" wrote:

How do I use the custom validation. I want to enter a validation which does
not allow the cells in column G to be more than the cell on the same row in
column E + 50.

I have selected all the cells, gone to Data Menu, Validation. Then on the
Settings tab picked Custom and then need to type the formula. Ive treid a
few but cant seem to get it right.