Microsoft Office Tutorials and References
In Depth Information
Select the cell ranges K6:K17 and K19:K30 .
On the Home tab, in the Styles group, click Conditional Formatting , point to Color
Scales , and in the top row, click the second three-color scale from the left to apply
the conditional format to the selected cells.
CLEAN UP Close the Formatting workbook, saving your changes if you want to.