hilighting entire row

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" <mangesh.24qdxn_1142459703.2381@excelforum-nospam.com> wrote in
message news:mangesh.24qdxn_1142459703.2381@excelforum-nospam.com...
>
> 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
>

Select all cells by clicking the square in the upper left hand corner of the
sheet.

Click Format->Conditional Formatting

Select "Formula is" and enter this formula (with both equals)

=$D1="completed"

click format and go to the "Patterns" tab. Select the color you want.
Select "OK" twice.

Now whenever a cell in column D equals "completed" the whole row will be
highlighted. Change D to the column you want.

"mangesh" wrote:

>
> 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
>
>