Question

create and apply a new conditional formatting rule for the selected cells d2:d15. apply the default icon set three traffic lights (unrimmed) icon set, but show only the icon, not the cell value. change the values so the green circle icon (the first icon) will be applied if the cell value is >=90 percent and the yellow circle icon (the second icon) will be applied if the cell value is <90 and >=10 percent.

Explanation:

Step1: Select the range D2:D15

First, click on cell D2, then drag the mouse down to cell D15 to select the range of cells where we will apply the conditional formatting.

Step2: Open Conditional Formatting

Go to the "Home" tab in Excel. In the "Styles" group, click on "Conditional Formatting".

Step3: Choose Icon Sets

From the "Conditional Formatting" menu, select "Icon Sets" and then choose the "Three Traffic Lights (Unrimmed)" icon set.

Step4: Customize the Icon Set Rules

After applying the icon set, click on "Conditional Formatting" again, then select "Manage Rules". In the "Conditional Formatting Rules Manager" window, select the rule for the selected range and click "Edit Rule". In the "Edit Formatting Rule" window, under "Icon Style", set the rules:

• For the green circle (first icon): Set the type to "Percent" and the value to ">=90".
• For the yellow circle (second icon): Set the type to "Percent" and the value to ">=10" and "<90". (Note: The third icon's rule will adjust accordingly, but we focus on the first two as per the problem.)
• Ensure that "Show Icon Only" is selected.

Step5: Adjust Cell Values (if needed)

If the existing cell values in D2:D15 do not meet the criteria, modify the values so that some are >=90% (to show the green icon), some are between 10% and 89% (to show the yellow icon), and the rest (if any) can be <10% (to show the red icon, though the problem focuses on green and yellow here). For example, set some cells to 95%, 85%, 15%, etc., to test the formatting.

Answer:

The conditional formatting with the "Three Traffic Lights (Unrimmed)" icon set is applied to range D2:D15, with green icon for values >=90% and yellow icon for values >=10% and <90% (showing icon only). Cell values are adjusted to meet these criteria.