Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting

    Hello


    Could any one help me with the following conditional formatting.

    I am trying format the cell above the cell that has specific text "R".

    This covers a large worksheet.

    So there will more than one instance of the specific text.

    I am copying information from SAP into Excel so the specific will change every time.

    I know you can have conditional formats for each cell but this would take far too long.

    Thank you in advance

    Brian

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Brian,

    Welcome to the Lounge as a new poster!

    If you highlight the range of all cells (A1:G4) as shown below:
    R-Highlight.JPG
    Then as the formula for the conditional enter: =A2="R"
    Then select the desired formatting and you should be all set if the shown picture above is what you are after.
    HTH
    Last edited by RetiredGeek; 2014-07-02 at 21:17.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    ...so the specific will change every time
    RG,

    If I am not mistaken, I believe the OP is indicating that the specific can change each time, meaning that the specific may not always be an "R". This would require editing the conditions. Perhaps Brian is looking for something more like:

    If you highlight the range of all cells (A1:G4) as shown below:

    Condition1.png

    Then as the formula for the conditional enter: =A2=$J$1
    Then select the desired formatting and you should be all set. You can easily change the specific by changing the value of J1 to the specific you require.

    condition2.png

    condition3.png

    Condition4.png

    Apologies if I have misread the intent.

    Maud

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Maud,

    An excellent point! Let's see what the OP has to say.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  5. #5
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Confused as to whether the specific will "change" as to by location or by text.

  6. #6
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Retired geek worked perfectly.
    Thanks both of you

Posting Permissions

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