How to use VBA to change the active cell color in an Excel ... on any worksheet—in short, when you change the active cell. (It doesn’t work on a chart sheet.) What you can’t do, to my ...

You can also create color scales, which code cells based on their value ... it's very easy to add data bars to a spreadsheet in Excel with just a few clicks. How to create data bars in Excel ...

How to Use TODAY() to Highlight Fast-Approaching Dates in an Excel Sheet ... do so when there isn’t an adequate built-in rule. Let’s start with yesterday: This rule applies a red fill color ...