Excel Tip - Conditional Formatting.

Excel Tip - Conditional Formatting

This tip comes in handy when you are using Excel for a report. You can set it up so that when values are above or beneath a particular threshold, the data will be formatted in a particular manner.

Here is an example of a way you can use conditional formatting:
You have a spreadsheet you use to track deadlines. You can set the format for the "due date" column so that if the due date is less than 2 weeks away, the cell will be shaded yellow. Once the due date has passed, the date will be underlined and in red. This way, you can quickly see which due dates are coming up, and which deadlines have slipped.

To use conditional formatting:

1. Select the cells you want to format.
2. Click on the Format menu, and select Conditional formatting.
3. Set the format appropriately.

For additional information, see Learn Excel Formulas from A to Z - Atlanta Excel Training Class.