How do I... Use pre-built style features to format Excel 2007?

Conditional formatting

Conditional formatting
With conditional formatting, you can emphasize unusual values or otherwise highlight specific information. Information and data will stand out as important to your audience is a clear visual way. Clicking the Conditional Formatting icon reveals a set of menu options, including:
  • Highlight Cells Rules
  • Top/Bottom Rules
  • Data Bars
  • Color Scales
  • Icon Sets

By Mark Kaelin

Mark W. Kaelin has been writing and editing stories about the IT industry, gadgets, finance, accounting, and tech-life for more than 25 years. Most recently, he has been a regular contributor to,, and TechRepublic.