An example Excel worksheet is provided for your convenience as a free download.

Previously, she was editor in chief for The Cobb Group, the worlds largest publisher of technical journals.

For this one, you only have two options Is blank and Is not blank.

Its super easy to use and once you get the hang of it, youll likely find yourself using it more and more.

Plus, we have some terrific tips to take your Conditional Highlighting to the next level.

So, well start by setting up Conditional Highlighting for numbers.

Whenever inventory gets low, you want to be alerted when you view the sheet.

As you can see, you have a variety of options for creating your rule for numbers like Is equal to, Greater than, Less than, or Between.

For our example, we want to see when inventory is less than 50 units.

You can have the text stand out with italics, bold, or a certain color or have the cells highlighted with a specific color.

If you prefer to create your own appearance, you can pick Custom Style to set it up.

Now you will see that conditional formatting appear for the cells you chose.

And perhaps you want more than one Conditional Highlighting rule.

When a student receives an A we want it highlighted in yellow and for an F we want it highlighted in orange so that both pop out at us.

Here again, you have many options for the conditions you want to use such as Is, Is not, Starts with, and Ends with.

For our example, we want to see when A student receives an A.

So, well enter A.

Then, well scroll down and choose Yellow Fill for our spreadsheet and tap Done.

The format window should still be open at this time, so well enter our second rule.

Tap Done.

Conditional Highlighting for dates comes with many options from Today, Yesterday, and Tomorrow to Before, After, and In the range.

Next, well enter the date range we want to use and pick the text or highlighting we want to apply.

In our case, the range is March 1 through March 10 and the appearance will be bold text.

You might use a spreadsheet to log workouts, tasks, or another activity that uses a period of time.

Durations gives you similar options as numbers like Equal to, Greater than, Less than, and Between.

Were going to choose Greater than or equal to and then enter two hours (which will display as 2h).

Any project that we spent two or more hours doing will be highlighted and easy to spot.

Excel Conditional Formatting For Dates On Mac