5 Replies Latest reply on Dec 14, 2017 9:30 AM by Stephen Bava

    Highlight cells based on multiple factors

    Stephen Bava

      I want to highlight everything by row, that is 150% or 50% of the average of each row brown. And it there is no value at all, highlight yellow. Attached is a sample workbook.

       

      Below is a screenshot what I am thinking. By row, have an average column at the end, and then highlight cells in the row brown if they are either 150% or 50% of that average. Then highlight yellow if there is no value.

       

      Trend Report Screenshot.PNG