Icon Set Conditional Formatting on multiple cells

[Rudy190]

Hello,

I am trying to use the stoplight icon set to measure if the number in one column is great or less than the number adjacent to it in the next column.

I haven't been able to figure out how to set multiple rows in one swoop. I can do 1 row of 2 adjacent cells, but the formula always has to be an absolute cell, and I want to copy the formatting down so the adjacent cell it looks at is always the next row down.

Any ideas?
Thanks in advance for your help.

 

[Steve=True]

Hightlight the whole row (i.e. A1:a10)

Do your conditional formatting, but only pick the first reference point as the comparison

(i.e $b$2)

Eventhough it looks abosolute, it will apply the conditional formatting for each cell in the range individually just like you are doing for $b$2

 

[SoBo]

nice trick- this has *gotta* be a bug, albeit a useful one.. I actually used it for multiple columns and rows.. works as described.. thanks, Steve!

 

[Steve=True]

You are welcome.

Not sure if it is a bug, but that is the way it works.

Thanks for the positive comments.

 

[davidmarsden]

I cannot get this to work in 2010.
I have two column such as below.
A B
1 2
2 2
3 3
4 6
5 5

and I want to display an icon dependent on B's relation to A per row. IE is B1 > A1.

I can only manage to use the absolute references, such as A1 all of the conditional formatted cells in B1:B5.

Can you help?