Here's how to build smarter checklists in Excel using checkboxes, conditional formatting and task dependencies to help with ...

Your spreadsheets don't have to be dry, soul-killing pages of numbers. With Excel 2007's conditional formatting, you can add all sorts of eye-catching visuals to your data. Conditional formatting ...

Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border. They can also change the text's color. For ...

Click the Conditional Formatting button. Click the Add button, name the rule, and choose a color. ... Add quotation marks around the text, then click OK for all dialog boxes.