Suppose you are doing this on row 2. Highlight the whole row by
clicking on the row identifier, then Format | Conditional Formatting.
Select Formula Is rather than Cell Value Is and enter this fomula:

=$B2="Exception"

then click on the Format button and choose your effect. OK your way
out.

If you want to apply the format to other rows, use the Format Painter
icon.

Hope this helps.

Pete



On Nov 19, 1:43 pm, Candace wrote:
I am trying to use conditional formatting to make an entire row red if the
content of column B for that row has the word "Exception" in it. I only
succeeded in conditionally formatting that particular cell. How can I get the
formatting to apply to the entire row, when the cell in column B of that row
contains the word "Exception"?