Highlight Row if cells in two adjacent columns contain the text Yes
Results 1 to 4 of 4

Thread: Highlight Row if cells in two adjacent columns contain the text Yes
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Mar 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Highlight Row if cells in two adjacent columns contain the text Yes

    Hi everyone,

    I would like to highlight the rows in my spreadsheet where columns G and H both contain the text "Yes". Any help would be great I've tried conditional formatting and VBA but can't seem to get either to work for what I need.

    Thank you!

  2. #2
    Board Regular
    Join Date
    Feb 2010
    Location
    Wisconsin
    Posts
    2,350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlight Row if cells in two adjacent columns contain the text Yes

    Conditionally format cell A1 with this formula:

    =AND($G1="Yes",$H1="Yes")

    Select your formatting.
    Copy formatting accross row.
    Copy formatting of row down as needed.

  3. #3
    New Member
    Join Date
    Mar 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlight Row if cells in two adjacent columns contain the text Yes

    Thanks! this worked perfectly

  4. #4
    Board Regular
    Join Date
    Feb 2010
    Location
    Wisconsin
    Posts
    2,350
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Highlight Row if cells in two adjacent columns contain the text Yes

    You're welcome, glad it works.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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