Highlight one or more cells in a column and click "Conditional Formatting" in the Styles section of the Home tab on the ribbon. Click "Highlight Cell Rules" to display a menu that contains If-Then ...

Expand Highlight Cells Rules -> Text that contains. Type Completed and change the formatting style. Similarly, create conditional formatting for other status options and manage your project tasks ...

B. Format cells that contain specific text You can also use the Conditional Formatting feature to make certain text (letters, word, phrases, etc.) stand out. 1.

For instance, if you create a conditional formatting rule that highlights cells with values over 100, and one of the cells in your set changes from 95 to 102, that cell will become highlighted.

Merging cells avoids adjusting cell width or height if it contains a multi-line title or lengthy text. However, while merging ...

For Excel 2010, right-click on the cell that contains the conditional formatting to move to other cells. Click Copy from the pop-up menu. Even if numerous cells contain the formatting, you only ...

In Excel 2003, do the following: Select cells B3:E11. Choose Conditional Formatting from the Format toolbar. Choose Formula Is from the Condition 1 dropdown.

Give conditional formatting a try - it's a groovy Excel technique that changes cell appearance based on rules you set up, like "Turn the cell green if its value is less than 100." ...

If you want to highlight a single cell in the subtotaling rows, select only the single column before applying the conditional format. You could even add a second conditional formatting rule.