Conditional formatting allows you to automatically get Excel to change the appearance of some cells based on their values. This is particularly useful if you need something to stand out so that as you scan the worksheet you are quickly drawn to what you are looking for. Here in part 1 I get you started with highlight cells rules, data bars, color scales, icon sets and top-bottom rules. You will also see how to clear a rule.
Click here for part 2 of conditional formatting