77-420 · Question #15
Add conditional formatting. Color Scales: Green -White-Red Color Scale Midpoint: Percentile, "70" Maximum: Number, "25"
Step 1: Click cell C3 Step 2: Shift-Click cell S25. Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule... Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green. Step 5: In the same…
Question
Explanation
Step 1: Click cell C3 Step 2: Shift-Click cell S25. Step 3: On the Home tab, under Format, choose Conditional Formatting, and choose New Rule... Step 4: In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green. Step 5: In the same dialog box set Midpoint Type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Aleq set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.
Topics
Community Discussion
No community discussion yet for this question.