Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting (97)

    Hi all
    How can I make a Roll change color if a Cell says Yes
    I want Rolls A2, A3, A6, and A7 or from A to E to be gray is cell E contains the word Yes
    I know its conditional formatting but I don

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting (97)

    Select A2:d8
    Format - conditional formatting
    Formula is
    =UPPER($D2)="YES"
    Format button - patterns to gray

    Steve

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (97)

    Steve,
    Very interesting solution. Would you mind explaining how ir works?
    Thanks,
    Jeff

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting (97)

    Cond format works when the formula is "TRUE"

    The formula given:
    <pre>=UPPER($D2)="YES" </pre>


    is TRUE when the UPPERcase value in the D column (note it is LOCKED on Col D) in the RELATIVE row = "YES"

    I used Upper to allow "yes", "Yes", "YES", "yEs", etc as all possible "Yes" responses.

    You could have easily put:
    <pre>=$D2="yes" </pre>


    But ONLY "yes" rows would have highlighted, not any variant.

    Steve

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting (97)

    Thanks, Steve.

Posting Permissions

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