Use CF with a formula of
=AND(A2<>"",A2<>999)
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 2nd, 3rd & 5th 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
Use CF with a formula of
=AND(A2<>"",A2<>999)
Thanks Bob. It worked.
Bookmarks