Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi All,

    Please see attached and help me stop this brain freeze. As you will see in cell F-3 I have conditional formatting. My problem is that it is currently red. What I want is if all the cells in H,I,AND J are blank then the color should be yellow. It should only change to red if either one of them is answered "Yes"

    Thanks again for the help,
    cvbs[attachment=83573:Sample.xls]
    Attached Files Attached Files

  2. #2
    3 Star Lounger
    Join Date
    Nov 2005
    Location
    Asia Pacific, Bangkok Metropolis
    Posts
    378
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='cvbs' post='773480' date='03-May-2009 11:16']Hi All,

    Please see attached and help me stop this brain freeze. As you will see in cell F-3 I have conditional formatting. My problem is that it is currently red. What I want is if all the cells in H,I,AND J are blank then the color should be yellow. It should only change to red if either one of them is answered "Yes"

    Thanks again for the help,
    cvbs[attachment=83573:Sample.xls][/quote]

    Does the attached do what you want? I have modified the CF for you.

    use this formula in your CF to return TRUE for the condition when cells H3, I3 and J3 is blanks

    =AND(H3="",I3="",J3="")
    Attached Files Attached Files
    Hope this is helpful

    francis, <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

    My Reading

    Pivot Table 101
    Pivot Table
    Array

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Another possibility is to make the background of cell F3 yellow by default (in the Pattern tab of Format | Cells...), and use conditional formatting to change it to red if at least one of the cells H3:J3 contains "Yes", using the formula

    =OR($H$3="Yes",$I$3="Yes",$J$3="Yes")

    See the attached version: [attachment=83575:Sample.xls]
    Attached Files Attached Files

  4. #4
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Harrisburg, Pennsylvania, USA
    Posts
    168
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks guys... I knew this board was great !!

    Much appreciated

Posting Permissions

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