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