With conditional formatting you can tell Excel to apply a certain type of formatting to specific cells based on a specific condition.
For instance, in the example below, I am telling Excel to apply a conditional formatting to any figure in my selected range which is over 150.00 – The conditional formatting I told Excel to apply is: To all numbers which cross $150.00, to the color Red.
1. Select the Range
2. Click the Home tab
3. Click the command ‘Conditional Formatting’ located under the ‘Home’ tab and ‘Styles’ Group (see diagram below)
4. A drop down list of options will appear on the screen
5. Scroll down to ‘Highlight Cells Rules’, then across to ‘Greater than…’, and Click on it.
6. The ‘Greater than’ dialog box will appear on the screen apply the conditions you want (see the diagrams below for more info.). I give Excel the conditional formatting command to turn to the color red, all the numbers in the selected range below, which is above 150.00
7. Click the ‘OK’ button
Excel would have performed the conditions for you.
Lesson 39: How to apply a Style to a Range