If you haven’t checked out Excel’s conditional formatting feature recently, you’re missing out on some nice enhancements. The feature formats a cell based on its value. Excel continuously monitors the cell value and updates the formatting as the cell value changes. Conditional formatting has traditionally been limited to basic cell formatting such as fill and font color, but, in modern versions of Excel, it can do much more. For example, it can create data bars, color scales and icon sets.
My recent CalCPA Magazine article talks about icon sets and how to customize them. Excited? Me too!
Check out the full article here: Icon Sets Article
If you'd like to be notified when I write a new Excel article, enter your name and email and click SUBSCRIBE. You can unsubscribe anytime, and I will never sell your email address.