Conditional formatting is a great way to make your life easier with Excel. All you’re basically tell it to do is, “If this is the case, then do this.” Let’s see how one form of conditional formatting works. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.

* * * * *



1. Highlight the cells on which you want to use conditional formatting. Here, we are selecting the “Quantity Backordered” cells. Notice that there are both positive and negative quantitative values.

2. We want the cell to appear yellow if the amount is zero or below. Click “Conditional Formatting” under the “Home” tab as shown below.

3. Mouse-over “Highlight Cells Rule” and click on “Less Than…”.

4. Now, in the dialog box under “Format cells that are LESS THAN:”, we want to put the number 1.

5. You can then change the colors of the conditionally formatted cells. Choose “Custom Format…”.

6. This dialog box will allow you to change a number of aspects of your formatted cells, including (but not limited to) the font and color.

7. Now, under the “Fill” tab, we can choose the yellow we originally wanted.

8. Now, after clicking OK, it now fills the formatted cells with yellow.

If you have any question or suggestion, feel free to comment or email us at questions@pbttinfo.com

See you soon for the next trick!

Jess – Desktop Training Academy