Microsoft Excel’s conditional formatting is a wonderful “automatic” feature that allows you to formats cells based on the value of those cells or the value of the formulas in those cells. For example, ...

We've all built a rainbow spreadsheet in Excel, but in reality, your data shouldn't look like a bag of Skittles. While color-coding feels productive, it's hard to audit, impossible to automate, and ...

Conditional formatting highlights key information in a spreadsheet so it’s easy to see at a glance. This beginner’s guide gets you started. Spreadsheets usually hold a wealth of information, but it ...