1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel conditional formatting

Discussion in 'Business Applications' started by gurutech, Jul 2, 2007.

Thread Status:
Not open for further replies.
  1. gurutech

    gurutech Thread Starter

    Joined:
    Apr 23, 2004
    Messages:
    2,960
    I don't remember if I asked this before, but I have a range of cells that I want to change color depending on whether the value of one of the cells in the range is "greater than or equal to" or "less than" the value of another cell in the same range.

    I've figured out how to change the "Cell Value Is" dropdown to "Formula Is", and that works for the most part, but if I have a range of 10 cells, only the one in the lower right is completely correct. The other cells have their formulas changed to reflect the position changes within the range. ie. if I have cells A1:B5 selected, and have the formula set to: =B4>B3 (red) and =B4<B3 (green), then only cell B5 will contain these formulas. Cell A5 will show: =A4>A3 (red) and =A4<A3 (green), etc...

    How can I make it so that ALL cells will indicate =B4>B3 (red) and =B4<B3 (green) ?? - without having to manually go back into each cell and "fix" it...
     
  2. OBP

    OBP

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    Use the $ sign before the rows and columns to make them "Absolute", i.e. =$B$4>$B$3
    You can just make the Column OR Row Absolute, i.e. $B4 or B$4
     
  3. gurutech

    gurutech Thread Starter

    Joined:
    Apr 23, 2004
    Messages:
    2,960
    So THAT'S what the $ is for! I always thought it was to show how much money I DON'T have! :)

    Thanks!
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/590892

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice