+ Reply to Thread
Results 1 to 3 of 3

Help with Excel conditioning formulas

  1. #1
    Registered User
    Join Date
    07-23-2011
    Location
    SF, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Exclamation Help with Excel conditioning formulas

    I have created a worksheet with conditional formulas that highlight cells based on their values. I have a formula that highlights cells with values between 0-10 a certain color. However I also have cells I blocked out. Is there a way to get the conditioning to not apply to the blocked out gray cells? Is there a formula that will limit the conditioning effects to only cells that are not gray? Please help! Thank you!

  2. #2
    Registered User
    Join Date
    07-23-2011
    Location
    SF, CA
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help with Excel conditioning formulas

    bump..........

  3. #3
    Valued Forum Contributor
    Join Date
    11-11-2008
    Location
    Euro
    MS-Off Ver
    2007, 2010
    Posts
    470

    Re: Help with Excel conditioning formulas

    Using 2 conditional formatting and set their priority: 1st for the with formatted GRAY cell, and 2nd for condition value in 0-10 with a certain color
    Best regard, -)iger-/iger
    If you are pleased with a solution mark your post SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1