Thread: Data Validation
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
knock knock is offline
external usenet poster
 
Posts: 2
Default 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?