Basic Formatting

  • Basic Formatting Tips for Excel - Let’s face it, spreadsheets look boring, rows and rows of numbers and text. However, with a little bit of formatting, we can improve things drastically. In this blog post, I’m going to introduce you to some of the basic formatting features in Excel that can make your spreadsheets look a little bit more interesting. Adding ...

Conditional Formatting

  • Introduction to Conditional Formatting (Part 1) - Hi and welcome to part one of this two-part blog post series on Conditional Formatting. In this blog post, I will introduce you to the Excel feature of Conditional Formatting. I'll give you a brief idea of what it can be used for and provide you with some examples.
  • Introduction to Conditional Formatting (Part 2) - Welcome to part two of this two-part series of blog posts introducing Excel Conditional Formatting. If you haven't read part one in this series, then I suggest you read it first by clicking here. In this second blog post, we'll look at Data Bars, Color Scales, Custom Rules and how to Manage Rules.
  • Conditional Formatting Icon Sets - Hi and welcome to this blog post on Excel Conditional Formatting Icon Sets. In this blog post, I'll describe what Icon Sets are, describe how you can edit the Conditional Formatting rules associated with Icon Sets, then finish up with a couple of examples.