Conditional Format based on value of another cell

[durbat2]

Hi

I have a spreadsheet and need to automatically colour a cell in col A
green if the value in col Z of the same row is between 0.8 and 1.1

Conditional format with a formula seems to be the logical choice but I
can't get my head round the logic function required

Thanks for looking

Martin

 

[Bob Phillips]

Assuming the CF is in A2

=AND($Z2>=0.8,Z2<=1.1)

 

[durbat2]

Assuming the CF is in A2

=AND($Z2>=0.8,Z2<=1.1)

--
__________________________________
HTH

Bob










- Show quoted text -

Thanks for that, does the job a treat. Just an hyperthetical question,
if I wanted another cell to be between the same limits ?

 

[Bob Phillips]

=AND($Y2>=0.8,Y2<=1.1,$Z2>=0.8,Z2<=1.1)

 

[David Biddulph]

As a matter of interest Bob, why the mixture of absolute & relative
addressing, or has it just been a long week?

 

[Bob Phillips]

Good question, it has to be the long week excuse <g>

They should all be column absolute, row relative seeing as it is CF.