Data Validation
 

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?