View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default Set a Conditional Formatting Q

How do I set a conditional formatting condition in E6 if the value in
E6 is negative and greater than 20% of the value in D6 ?

I wish to copy this conditional formatting to a range of cells, so the
formula would have to be relative

Thanks