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

    Conditional formatting for Individual Parameters

    srikanth ganti

      Morning,

       

      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,

       

      Sri