View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] durbat2@googlemail.com is offline
external usenet poster
 
Posts: 21
Default 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