If you don't want to set up the sheet yourself, download an Excel Gantt chart template here. Here's more on using conditional formatting in your spreadsheets. Excel Gantt chart template Read More ...

Conditional formatting is powerful, but you can avoid frustration by learning how and when Excel evaluates rules. The interface isn’t particularly intuitive, but it does allow you to edit rules ...

You can effectively spot high-priority tasks in Excel using conditional formatting. There are a few approaches, depending on how you prioritize your tasks in Excel (High, Low, Medium, 1,2,3, or A ...

Open an Excel workbook and select Conditional Formatting > New Rule. Select Format only cells that contain . Select Cell ...

This time we will use one of the new types of conditional format that Excel 2007 introduced – the data bar. Step one. Add a column to our data to hold references to the SalesTotal values: Step 2. Use ...

With the dates selected (C3:C37), click the Home tab, click Conditional Formatting, and then choose New Rule from the dropdown (Figure B). Excel opens the new Conditional Formatting pane to the right.