Format Rule: Color Ranges
To format values according to the required condition, click the data item menu button, select “Add Format Rule”/“Color Ranges” and choose the required color set:
The working principle is the same as for the “Format Rule: Icon Ranges” highlight rule:


