 |
| Conditional Formatting |
- Highlight Rules
- Top-Bottom Rules
- Data Bars XD
- Color Scales
- Icon Sets, and of course
- Customizing your own rule.
PS: When adding a new rule, add a formula that contains a condition and add new formatting.
Ex: =A1="PASSED"
Sunday, January 18, 2015
Conditional Formatting
From the lesson about IF, we can know more about making conditions in a more advanced manner through Conditional Formatting.
Conditional Formatting is applying unique cell formatting based on a certain condition. In Conditional Formatting you can apply the following
PS: When adding a new rule, add a formula that contains a condition and add new formatting.
Ex: =A1="PASSED"
PS: When adding a new rule, add a formula that contains a condition and add new formatting.
Ex: =A1="PASSED"
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment