Conditional Formatting

[chrisjack]

Hi, I am using Excel 2007. I have a column on my spread sheet called Comment. This field is either going to have one of the 3 scenarios. An “alpha numeric text” or “999” or “Blank” cell. If it is alpha numeric I want that cell highlighted else just leave it as it is if it has 999 or blank. In the example below, the 2^nd, 3^rd & 5^th cells will be highlighted. How can I accomplish this goal using conditional formatting or vba. Thanks in advance
Comment
999
2-November-commit
4-November-commit
999
2-October Miss

[Bob Phillips]

Use CF with a formula of

=AND(A2<>"",A2<>999)

[chrisjack]

Thanks Bob. It worked.