1 Reply Latest reply on Oct 14, 2018 7:20 PM by ShivaRam Chennapragada

    Conditional formatting for Individual Parameters

    srikanth ganti



      I have attached a work sheet with 3 parameters


      1. Billable
      2. Recoverable
      3. Total Utilization

      Need help in conditional formatting as per below criteria.


      If "Billable" < 0.775, then Red, else Black.


      If "recoverable" < 0.835, then Red, else black.


      If total "Utilization" < 0.98, then Red, else green.


      Thanks and regards,