Conditional formatting with IF Function

     

  • Change the colors with IF Functions
  • Create calculated field with below mentioned IF function and drag it into colors
  •  

     

     

     

     

    Sales Bifurcation based on Target - If Function

     

     

     

    Sales Bifurcation based on Target - If then Elseif Function