Learn how to make Excel format cells at your terms !
Description :
So Let's see what you'll learn from this course:
- Introduction to conditional formatting, what it is and what it does.
- Highlight Cell rules : Highlighting cells based on the comparison of their value to another value, highlighting dates, and highlighting duplicates in a data set.
- Top/Bottom Rules: Conditionally formatting the top or bottom % of the data and values above or below average.
- Using Data Bars in conditional formatting.
- Using Icon sets (Creating Traffic Lights conditional formatting).
- Using Color scales for conditional formatting.
Get Course