Customizing Conditional Formatting
Excel’s preset conditional formatting is great for most conditions, but if you want to set your own parameters and formatting, you can do so by creating a new rule.
Create a Rule
Select the cells to which you want to apply your conditional formatting.
On the Home tab, click the Conditional Formatting button, and choose New Rule from the gallery to display the New Formatting Rule dialog box.
Select the type of rule you ...
Get 2007 Microsoft® Office System Plain & Simple now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
