Excel 2007 Conditional Formatting - Why would I want to use that? Originallyl Posted April 14, 2008
A nifty feature in Excel 2007 is Conditional Formatting. It will help you identify numbers that meet criteria that you set by highlighting it or denoting it another way.
For example, let's say you have a list of numbers and you need to identify the cells with values less than 500.
-In Excel 2007
1. Highlight all the cells that have the numbers you want to evaluate
2. Click the Conditional Formatting button in the Ribbon
3. Select Highlight Cells Rules > Less Than...
-In the Format Cells Less Than field
4. Enter '500'
5. Click 'OK'
-All Cells less than 500 are highlighted
You can also apply:
- Color Scale
- Data Bar (kinda like a bar graph)
- Icons
As other methods to identify numbers.
That's it!
| 
