Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with data validation
Hi all
Cell C23 has a value. Data is input in range G23 to R23. I want excel to be able to check the value in C23 each time an only allow the data to be input in range G23 to R23 if it is equal to or less than C23. If it is more than C23 I want to display an error message. Any ideas?? Thanks WJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with data validation
Check the answer in your first post.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- wrote in message ... Hi all Cell C23 has a value. Data is input in range G23 to R23. I want excel to be able to check the value in C23 each time an only allow the data to be input in range G23 to R23 if it is equal to or less than C23. If it is more than C23 I want to display an error message. Any ideas?? Thanks WJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |