Conditional formatting is a great way to dynamically apply certain formatting to your spreadsheet data when certain conditions are met.
If you are new to conditional formatting you can pick up the basics here.
If you’re already familiar with conditional formatting, or just curious, here are “10 cool ways to use Excel’s conditional formatting feature”
1: Distinguish business rule violations
2: Display simple icons
3: Highlight a row based on a single value
4: Create a dynamic record highlight
5: Compare values
6: Compare lists
7: Create alternating bands (aka zebra stripes)
8: Find duplicates
9: Find discrepancies
10: Find the smallest or largest duplicate
If you’re interested in any of those you can hop over to Tech Republic for all the details you need.