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
|