What is CF?
Conditional Formatting helps us to change the appearance based on a condition/criteria.
Let us walk you through the percentage range conditional formatting with an example.
Where is CF?
Home-->Conditional Formatting-->Create Rule
Set "Format by" as Classification
How does it work?
The highest value in the selected column for CF will be used for calculating the percentage range.
Formula:
Highest value in the column x (Range/100)
For instance:
Please check below the YoY column, to which CF range will be set. The criteria is to have a green triangle on the left of the value in the selected column for 0 -50 percentage. 103 being the highest percentage value in the column, any value between 0 and 51.5 percent will have the green triangle.
From Range: 0 (value >= (103x0/100 =0))
To Range: 50 (value <= (103x50/100 = 51.5))
Case 1: One row below 51.5
Case 2: One row with 51.5
