As others have implied ,Conditional formatting applies to only the
one cell so either you have to pu it in every cell or use Even Code in the
Sheet Module. Something like:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Target, Columns("B")) Is Nothing Then Exit Sub
E = InStr(1, Target.Value, "Exception", 1)
If E < 0 Then
Target.EntireRow.Interior.ColorIndex = 3
End If
End Sub
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Candace" wrote in message
...
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"?