Learn how to apply advanced formatting to your tabular data using Excel's conditional formatting options. Every marketer should know how to rock them.

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started using conditional formatting.

How to create conditional formatting rules in Excel Once the custom value formats exist, you can apply them using conditional formatting rules. Right now, the format is set to General.

Excel's conditional formatting lets you customize how your data displays, from changing colors and shading to adding icons and more. Here's how it works.

As mentioned in the intro, you can use conditional formatting to make certain values stand out with colored text and backgrounds. You can, for example, indicate problem data values in red, and ...

Software engineer Chandoo shares some Excel conditional formatting tricks that make for good-looking and useful spreadsheets, like a Gantt chart.

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.

If you are interested in creating your own rules for your Excel spreadsheet, then make sure to read How I use conditional formatting to automate my Excel spreadsheets like a pro.