Conditional Formatting

[Sineadd]

Hi

I am trying to apply conditional formatting to a column of cells.

Basically i have data in columb b and column C.

What I want to do is highligh all cells that are greater than there adjacent cell to highlight in red and lower to highllight in green

I can get it to do it for the first cell or do each one seperatley but im guessing there is a quicker way

Anyone can help?

Thanks
Sinead

 

[steve the fish]

Re: ~Conditional Formatting

If you can do it for the first cell then changed the 'applied to' to cover the range required.

 

[Sineadd]

Re: ~Conditional Formatting

I have tried that but it just turns them all the same colour!

 

[Sineadd]

Re: ~Conditional Formatting

Have it sorted I had absolute cell referencing on the first part!

Thanks for the replies

 

[steve the fish]

Re: ~Conditional Formatting

Are you using a formula? Id use 4. Two for red, one each column and two for green, one each column.

=AND(B1<>"",C1<>"",B1 < C1)<c1) applied="" to="$B:$B" formatted="" red
applied to =$B:$B formatted green
=AND(B1<>"",C1<>"",B1 > C1) applied to =$B:$B formatted red
</c1)><c1) applied="" to="$B:$B" formatted="" red
=AND(B1<>"",C1<>"",B1 < C1) applied to =$C:$C formatted red
<c1) applied="" to="$C:$C" formatted="" green
=AND(B1<>"",C1<>"",B1 > C1) applied to =$C:$C formatted green


Try that.</c1)></c1)>