Results 1 to 3 of 3
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    220
    Thanks
    13
    Thanked 0 Times in 0 Posts

    Question Conditionally format a row in which a cell meets the condition

    I have a rule to highlight every cell that contains specific text. The cells can exist in either of two rows. How can I format (highlight) the entire row in which a cell contains the condition? Thanks.
    JimmyW
    Helena, MT

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Jimmy,

    Can you supply a test worksheet showing the value and where it will reside?
    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,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Jimmy,

    Enter the following formula in the Edit Formatting Rule window

    Jimmy1.png

    In the Applies to section, enter the following range

    Jimmy2.png

    If "Yes" is entered into any cell on the 1st row between columns A and Z then all the cells in that row between A and Z will be highlighted. Extend the range or change the "yes" parameter as needed.

    jimmy3.png

    HTH,
    Maud

Posting Permissions

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