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 ?