Conditional Format based on value of another cell

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

Assuming the CF is in A2

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

--
__________________________________
HTH

Bob

" wrote in message
...
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

On 7 Aug, 11:26, "Bob Phillips" wrote:
Assuming the CF is in A2

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

--
__________________________________
HTH

Bob

" wrote in message

...



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- Hide quoted text -

- 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 ?

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


--
__________________________________
HTH

Bob

" wrote in message
...
On 7 Aug, 11:26, "Bob Phillips" wrote:
Assuming the CF is in A2

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

--
__________________________________
HTH

Bob

" wrote in message

...



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- Hide quoted text -

- 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 ?

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

"Bob Phillips" wrote in message
...
=AND($Y2=0.8,Y2=1.1,$Z2=0.8,Z2=1.1)


--
__________________________________
HTH

Bob

" wrote in message
...
On 7 Aug, 11:26, "Bob Phillips" wrote:
Assuming the CF is in A2

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

--
__________________________________
HTH

Bob

" wrote in message

...



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- Hide quoted text -

- 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 ?

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

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

--
__________________________________
HTH

Bob

"David Biddulph" groups [at] biddulph.org.uk wrote in message
...
As a matter of interest Bob, why the mixture of absolute & relative
addressing, or has it just been a long week? :-)
--
David Biddulph

"Bob Phillips" wrote in message
...
=AND($Y2=0.8,Y2=1.1,$Z2=0.8,Z2=1.1)


--
__________________________________
HTH

Bob

" wrote in message
...
On 7 Aug, 11:26, "Bob Phillips" wrote:
Assuming the CF is in A2

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

--
__________________________________
HTH

Bob

" wrote in message

...



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- Hide quoted text -

- 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 ?