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

Conditional Formatting Use conditional formatting to highlight chart elements such as bars, lines, areas, and data points.

We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...

With the use of Excel’s conditional formatting, you can set the rules once and let Excel do the highlighting for you.

When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just find an easier solution than writing code.