This rule will only color cells greater than a certain amount, with the color you specify.

For instance, I added a second rule that colored items larger than 2000 with green instead of red.

you could even create a completely customized rule by choosing the New Formatting Rule option.

Using Conditional Cell Formatting in Excel 2007

This is one of those really useful features that make Office 2007 a lot better than the prior versions.

image

image

image

image

image

image

image

image