Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validating | Excel Discussion (Misc queries) | |||
validating cells in the same row has unique values | Excel Worksheet Functions | |||
Validating non-blank cells in workbook | Excel Worksheet Functions | |||
Validating non-blank cells in Excel 'form' | Excel Discussion (Misc queries) | |||
Validating cells | Excel Discussion (Misc queries) |