MS Excel — Cool Conditional Formatting Tips!
A Few Things I Learned Recently…🏋️♀️
Conditional formatting is one of my favorite Excel visualization techniques. But it can confusing!
I’ve rounded up four techniques below that I have learned recently. I hope you find them useful!
1-Conditional Formatting in a Pivot Table
Pivot tables are my most frequently used “quick” analysis tool, but I could never get the formatting to “stick” when I did data updates.
Problem solved, thanks to Jon Acamp…
2 — Smart Ways to use Custom Formatting instead of Conditional Formatting in Excel — Part 1
Leila Gharani provides great content and I found the two YouTube videos below to be an interesting, and useful, twist on conditional formatting.
Definitely knowledge that is good to know and apply when the opportunity presents itself!
3 — Unusual use of Excel’s Custom Number Formatting with Conditions & Symbols — Part 2
4 — How to use Conditional formatting in Excel Chart
Although this technique can be a little cumbersome to implement, it’s definitely worth it in the right situation!
I hope you found these useful. I you have a particular favorite of the group, let me know in the comments below!
Personally, conditional formatting of pivot tables is my favorite!