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,948
    Thanks
    421
    Thanked 1,605 Times in 1,449 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,976
    Thanks
    156
    Thanked 769 Times in 701 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
  •