Results 1 to 3 of 3

Thread: Conditional Formatting

  1. #1

    Conditional Formatting



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Use CF with a formula of

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

  3. #3
    Thanks Bob. It worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •