Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
Validation
I need help with validation One of the condition that I needed to do is all pre 2003 computer must be replace with current model which equal to 120. so therefore I did this: (Year 2008) Data validation Validation criteria Allow: whole number Data: equal to Value: =c2:120 Error Alert Style: warning Title: Attention Error message: pre 2003 PCs must be replace with current model with equal to 120. Some reason this does not work. Another question If the number does not equal to 120, I want it to be bold or colour indicating that is not equal to 120. How do I do this? |
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) |