Highlight a row when a particular word is written in a cell

**Jvic28** · 05-23-2010, 10:25 AM

Hi,

Is there a way I can get a row highlighted when a particular word is written in a cell. Please see the attached file to explain futher.

Thanks

**pb71** · 05-23-2010, 11:23 AM

Use Conditional Formatting. I've attached an example.

In the example you have posted, select cells A11 to C11, for example.

On the Home tab, select:

Conditional Formatting
Manage Rules
New Rule
Use a formula to determine which cells to format
In the rule description type (in this case) =$C11="Invoiced" and choose the formatting

You can then use Format Painter to apply this conditional formatting to other rows in columns A to C (see attached example).

**Palmetto** · 05-23-2010, 11:28 AM

You can then use Format Painter to apply this conditional formatting to other rows in columns A to C (see attached example).

If you first select the entire range of cells in column-A, making sure the top most cell in the range is the active cell, the Conditional Format will automatically be extended to all cells in the range - no need for format painter.

**pb71** · 05-23-2010, 12:49 PM

Sound advice Palmetto, however, the range of cells selected (for the example posted) should include columns A to C for the formatting to extend across all cells in the range.

Originally Posted by Palmetto

If you first select the entire range of cells in column-A, making sure the top most cell in the range is the active cell, the Conditional Format will automatically be extended to all cells in the range - no need for format painter.