View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] william.mcseveney@ntlworld.com is offline
external usenet poster
 
Posts: 14
Default Validating cells

I have a daily threshold for vaction hours in cell C23. My data input
range per employee is G23 to R23. I want to ensure that excel will not
allow me to input a value in G23 to R23 if it is more than C23. How
can I get excel to lock the cells G23 to R23 and show an warning
message if I try to enter a value greater than C23.

Many thanks

WJ