Validating cells
Select G23 to R23.
From the Menu Bar,
<Data <Validation
Under the "Settings" tab,
Expand the "Allow" window and click on "Custom".
In the "Formula" window, enter:
=G23<=$C$23
Then <OK.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
wrote in message
...
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
|