change colour of the adjacent colomuns

**durga_ikon** · 05-10-2012, 06:53 AM

if cell 2 > cell1, colour changes to green, if cell 2<cell 1, changes to yellow.

**Fotis1991** · 05-10-2012, 06:58 AM

Hi

In Conditional format rules.

1) =a2>a1 >> Color green>>ok

2) =a2<a1 >>Color Yellow>>ok.

**durga_ikon** · 05-10-2012, 07:05 AM

thankx for nice n quick reply

**durga_ikon** · 05-10-2012, 07:08 AM

but, how to copy the same into down the cell, the same conditional format without doing one by one

**Fotis1991** · 05-10-2012, 07:19 AM

Highlight your range(Let's say A1:A100)

In Conditional format rules.

1) =$a2>$a1 >> Color green>>ok

2) =$a2<$a1 >>Color Yellow>>ok.

**durga_ikon** · 05-10-2012, 07:51 AM

it says " you can not use direct reference), if select the range of the cells

**durga_ikon** · 05-10-2012, 07:59 AM

look at this file.

**Fotis1991** · 05-10-2012, 08:19 AM

Highlight all your range..

Formula is.

1) =$c2>$b2

2) =$c2<$b2

Is it OK, now?

**durga_ikon** · 05-10-2012, 08:26 AM

ok thankx..

Re: change colour of the adjacent colomuns