Results 1 to 2 of 2

Thread: Formatting Problem in Excel 2007

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    holo man
    Guest holo man's Avatar

    Formatting Problem in Excel 2007

    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?

    Thanks!

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,841
    Articles
    0
    Excel Version
    O365
    Use a formula of

    =A9="p"

    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
  •