2 Replies Latest reply on Nov 5, 2018 6:02 AM by alex alex

    Calculation in table and color fill

    alex alex

      Hi!

       

      I have a table like:

      1.JPG

      Here, for each employee for each month "standard hours" and "actual hours" are shown. Also utilization KPI is given as well.

      Then I need to calculate actual utilization rate (=actual hours/standard hours) - and compare it with KPI.

      If it is within +-2% then it is OK, otherwise it is either UnderUtilized or OverUtilized.

      See result for this table in Excel:

      2.JPG

      As a result I shall have the following table (amount of employees with OK/Under-/OverUtilization) with a department/grade breakdown:

      3.JPG

      And I need to fill cells with similar colors as shown above (green for OK, red for Over-, Blue for UnderUtil).

       

       

      How can I do that? 

       

      Source file is attached...