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

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 ...

Conditionalformattings can apply other colors than just .Color. You can also apply theme, index or auto color. The same logic applies to most other conditional formattings. With the exception of ...

How to apply the conditional format in Outlook Calendar With or without an appointment, applying a conditional format is easy, and Outlook applies the code automatically.

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.