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
Comment
999
2-November-commit
4-November-commit
999
2-October Miss
