The supply chain manager for the distributors from Figure G.8

(b) wishes to see icons that indicate when the annual inventory turnover exceeds 90 and when it is below 30.

Transcribed Image Text:

Edit Formatting Rule Select a Rule Type: Format all cells based on their values Format only cells that contain Format only top or bottom ranked values Format only values that are above or below average Format only unique or duplicate values Use a formula to determine which cells to format Edit the Rule Description: Format all cells based on their values: Format Style Icon Style: Icon Sets Customs Display each icon according to these rules: kon when value is No Cell Icon when-90 and when < 30 Reverse Icon Order Show Icon Only < C Value Type 90 Number 30 Number OK Cancel