SKILLSHARE ULTIMATE EXCEL COURSE 4 CONDITIONAL FORMATTING MAKE YOUR DATA COME TO LIFE-iLLiTERATE

This class is #4 in a series called the Ultimate Excel Course.

In this class you will learn how to use Conditional Formatting to Make Your Data Come to Life.

Conditional Formatting is one of the most popular tools in Excel. It is used to automatically format (usually change colour) of cells dependent on their value. For example, change the colour of a cell if the date has passed, or if the value in the cell is larger than a specified value.

This feature can bring your spreadsheets to life. It provides clarity and people can instantly find what they need to know.

This class will cover:
- Using Conditional Formatting to highlight expired and due dates.
- Using Icon Sets show monthly comparisons. Here the RAG arrow icons will be used to compare this month sales versus last months.
- Using Data Bars to compare values and show progress towards a goal.
- Managing multiple Conditional Formatting rules and how to deal with conflicts.
- How to highlight an entire row instead of a single cell.
- Testing multiple conditions by embedding the AND and OR functions within our Conditional Formatting rules.