Using Conditional Formatting to Identify Key Values
Using Conditional Formatting to Identify Key
Values
Conditional formatting lets you set font attributes, colors, and other formatting options that
cause data to appear differently based on the value displayed in a cell. Most often, you’ll use
this feature to set an alarm that highlights data that is outside of an expected range. For
example, you might attach conditional formatting to a row of totals on a daily sales report,
displaying each cell’s contents in bold red letters if it falls below a target level and in bright
green if the number is significantly above average. In an employee roster
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.