Excel Conditional Formatting Mess
March 14, 2017
Fix a conditional formatting mess, and more, in this week's Excel news. Visit my Excel website for many more tips, tutorials and videos -- let me know if you're looking for something and can't find it there.
It's March 14th, and 3.14 is the rounded version of Pi, so Happy Pi Day! Did you know that Excel has a PI function?
If you don't need to know the radius, just multiply the diameter by Pi. There are lots more function tips, videos and examples on my Contextures website.
You can use conditional formatting to highlight one or more cells, based on rules. Sometimes though, the rules are duplicated automatically, and that can create a huge mess in your workbook.
The duplicate rules are usually created when:
If this happens to you, here's how to fix the problem -- or watch my video:
Get the sample workbook, and more details on my Conditional Formatting page.
Here are a couple of recent Excel articles that you might find useful.
Data Viz - Jorge Camoes has 10 reasons why we should take Excel dashboards seriously. I liked #5: "let your imagination run wild". He's got a new book on dashboards too, but it's only available in Portuguese. (Level - All)
Pivot Tables - Allen Arthur studied Social Journalism, and learned to love Pivot Tables, while working on his final project. His final paragraph was my favourite part of the story. (Level - All)
It's maple syrup season in Canada, and you could spend the whole month going to the maple syrup festivals and events. There's a long tradition of this -- here's a picture that my Dad took, long ago, at Upper Canada Village. I'm on the right, holding my sister's scarf to keep it out of the sap bucket, while my Mom and aunt look on. Good times!
That's it for this week! If there are topics that you'd like to see covered in future emails,
please let me know.
ddalgleish @ contextures.com
Note: I am an affiliate for some of the products mentioned in this email, and earn a commission on the sales.
Last updated: March 15, 2017 11:58 AM