Conditional Formatting

chrisjack

New member
Joined
Oct 22, 2012
Messages
15
Reaction score
0
Points
0
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[SUP]nd[/SUP], 3[SUP]rd[/SUP] & 5[SUP]th[/SUP] 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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Use CF with a formula of

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