Conditional formatting allows a user to create rules to automatically format cells to emphasize certain areas of a data range. For example, you can use conditional formatting to change the color or highlight certain numbers such as the highest number or lowest number. You can also use conditional formatting to compare different values or show repeated values. To change a condition after creating a conditioning formatting rule, you can simply modify the rule using the Rules manager instead of creating a new rule. To d this you select the cells that contain the conditional formatting, click on the conditional formatting button in the styles group and then select manage rules. You can then select the rule you want to edit from the conditional formatting rules manager dialog box, click edit rule and modify the setting.
Class, what does your reading say about conditional formatting? What can you find the Internet? Thoughts? Experiences?
Conditional formatting is used to highlight data based on condition. We can... View the full answer