K
knock
Validation
I need help with validation
One of the condition that I needed to complete 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?
I need help with validation
One of the condition that I needed to complete 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?