You probably are asking yourself, “What is formatting conditionally?” Formatting conditionally lets you apply special formatting settings that take effect when the contents of a cell meet specified conditions. For instance, if the values fall below a specific number, you can show those values in bold pink, and if the values are greater than a specific number, you can display those values in bold blue. Excel's Conditional Formatting command helps you easily format your values based on specific conditions.
In the upcoming To Do exercise, you step through the process of setting up conditional formatting for values on the Summary sheet in the Sales workbook.
Select the cells that contain ...