In your current sheet module paste in:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = "Completed" Or Target.Value = "completed" Then
Cells.Interior.ColorIndex = xlNone
Target.EntireRow.Interior.ColorIndex = 6
End If
End Sub

Only one row at-a-time will be highlighted; Is that what
you want?



"mangesh" wrote in
message ...

I want to highlight entire row automatically with yellow color if i type
"completed" in a cell of that particular row.

Could any one help me.


--
mangesh


------------------------------------------------------------------------
mangesh's Profile:
http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=522864