Solved: Excel conditional formatting

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

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...
 

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
 

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!
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

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 807,865 other people just like you!

Latest posts

Members online

Top