+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Conditional formatting-down for any greater or lesser value to change

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional formatting-down for any greater or lesser value to change

    Hello,
    This might be something simple I cannot solve. I am learning excel for work and I ran into a request I cannot make. My boss asked me to make a conditional format that would change a couple cell's colors all at once based on a value of another cell. Example, if one cell reached over 45% a couple others would all change green. Well I got that one without much trouble. Pretty much I got the formatting down for any greater or lesser value to change but not a between. I can't see to find out a way to make a couple cells change color all at once based on a value between 25% - 30%. Any help would be appreciated. Thanks

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,653

    re: Conditional formatting-down for any greater or lesser value to change

    Select Formula is from the dropdown, =AND($A$1>=25%, $A$1<=30%).

    The details of where the dollar signs appear depend on whether you're formatting a group of cells in a single row, or single column, or random cells.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-21-2010
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    2

    re: Conditional formatting-down for any greater or lesser value to change

    Wow, Thank you. That worked perfectly. Now that I see it I understand. Thanks again!

+ 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