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

What formula could I use within CF to express the following

If A1 in Sheet1 is less than or equal to 80% of the value of A1 in
Sheet2, then change text colour (I know how to format, just not sure
of the syntax of the formula)

Thanks