Because Small Business is Big Business

Conditional Formatting

Conditional FormattingWhen looking at a spreadsheet that’s chock full of information and row after row of data, it can be difficult to discern the bottom line at a glance.  Perhaps you want to know if members of your team met their individual sales goals for the month. Or which of your sales representatives was the top seller for the quarter.   Maybe you want to see if your expenses exceeded your budget for the year. You can easely have these things stand out in a spreadsheet by using conditional formatting

If you like the idea of adding a visual component to make it easier to quickly evaluate spreadsheet data, then conditional formatting is the tool for you!  There are several types of conditional formatting options.

The first type of  is based on ‘rules’ defined by the user.  Conditional formatting rules include options such as “Greater than…”, “Less than…”, “Above Average”, and “Below Average”.   When a rule is applied to a cell or range of cells, Excel evaluates the cell contents and if the rule is evaluated as true, special formatting is applied.

If you like additional technology tips, check out A Guide to Small Business Software Technology