Results 1 to 2 of 2

Thread: Formatting Problem in Excel 2007

  1. #1
    holo man
    Guest holo man's Avatar

    Formatting Problem in Excel 2007

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

    I like all cells in a sort to turn into formatted blue while the first-cell contains "p". However, I could not do it. In Conditional-Formatting-Rules manager, and the rule was: Formula: = "a9=p". The Format box contains black-text on a blue backdrop, and the “Applies To” field have the array of cells: =$A$9:$H$9.

    While I change the cell of A9 to "p" not anything happens.

    I also assume I will have to take away all the $ on the "applies to". Though, when I try to do, Excel puts-up the $ back.

    Any way to format works properly?


  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    Use a formula of


    Don't remove the $ from the APplies to.

Posting Permissions

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