![]() Here's the result of the rule applied to the range B4:F8 in this spreadsheet: ![]() Formulas give you maximum power and flexibility.įor example, using the "Equal to" preset, it's easy to highlight cells equal to "apple".īut what if you want to highlight cells equal to "apple" or "kiwi" or "lime"? Sure, you can create a rule for each value, but that's a lot of trouble. Instead, you can simply use one rule based on a formula with the OR function: ![]() By using your own formula, you take over the condition that triggers a rule and can apply exactly the logic you need. However, you can also create rules with your own custom formulas. With conditional formatting, you can do things like highlight dates in the next 30 days, flag data entry problems, highlight rows that contain top customers, show duplicates, and more.Įxcel ships with a large number of "presets" that make it easy to create new rules without formulas. Quick Start | Examples | Troubleshooting | TrainingĬonditional formatting is a fantastic way to quickly visualize data in a spreadsheet.
0 Comments
Leave a Reply. |