View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John John is offline
external usenet poster
 
Posts: 2,069
Default Conditionally highlight a row on a cell content

I have a large Excel 2007 table of items showing budgets, actuals, variances
and % variances. How do I highlight row text and background coloring whenever
the row % variance cell is less that -50% (ie, the row is more than 50% over
budget).