View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob
 
Posts: n/a
Default conditional formating

I have three columns. A contains actual values this month, B contains yearly
average, C contains sales target. I need to conditionally format column A if
the value in A is 10% above the value in B and 20% above value in C.

Also if the value in column A is below the value in B and C I need to colour
it a different colour.

Please help and thanks

Bob