Conditional formatting using multiple conditions - Excel 2007

[SKooLZ]

Hi Guys...

Please help, I'm trying to use the =AND formula to conditional format values in E column based on multiple conditons. e.g If E1 is equal to (Condition 1 is E1>= B1 )and (condition 2 is E1< C1) colour cell red.

<C1) green.
So the formula I'm trying and excel is rejecting is =AND(>=$D$82,<$E$82)

[TABLE="width: 354"]
<TBODY>[TR]
[TD="class: xl70, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl70, width: 78, bgcolor: transparent"]A
[/TD]
[TD="class: xl70, width: 78, bgcolor: transparent"]B
[/TD]
[TD="class: xl70, width: 78, bgcolor: transparent"]C
[/TD]
[TD="class: xl70, width: 78, bgcolor: transparent"]D
[/TD]
[TD="class: xl70, width: 78, bgcolor: transparent"]E
[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]1
[/TD]
[TD="class: xl70, bgcolor: transparent"].=0 <1
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]2
[/TD]
[TD="class: xl70, bgcolor: transparent"].=1<2
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, bgcolor: transparent"].>2
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl70, bgcolor: transparent, align: right"]100
[/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]

Thanks in advance

 

[Peter_SSs]

Try

=AND(E82>=B82,E82<C82)

 

[ChrisBM]

Just did a quick test and mine seemed to work:

Formula I tried:

=AND(E1>=D1, E1 < C1)

<c1)[ code]<c1)[="" code]<="" html=""></c1)[>

 

[SKooLZ]

Thanks Peter and Chris,both worked but I'm sure i had tried both those variations before but neither worked. Hay How, guess i was doing something wrong which is usually the case with me and Excel.

Much appreciated!!