software

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

Could any one help me.--
mangesh------------------------------------------------------------------------
mangesh's Profile: www.excelforum.com/member.php...foamp;userid=6746
View this thread: www.excelforum.com/showthread...hreadid=522864In your current sheet module paste in:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value = quot;Completedquot; Or Target.Value = quot;completedquot; 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?
quot;mangeshquot; gt; wrote in
message ...
gt;
gt; I want to highlight entire row automatically with yellow color if i type
gt; quot;completedquot; in a cell of that particular row.
gt;
gt; Could any one help me.
gt;
gt;
gt; --
gt; mangesh
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mangesh's Profile:
gt; www.excelforum.com/member.php...foamp;userid=6746
gt; View this thread: www.excelforum.com/showthread...hreadid=522864
gt;
Select all cells by clicking the square in the upper left hand corner of the
sheet.

Click Format-gt;Conditional Formatting

Select quot;Formula isquot; and enter this formula (with both equals)

=$D1=quot;completedquot;

click format and go to the quot;Patternsquot; tab. Select the color you want.
Select quot;OKquot; twice.

Now whenever a cell in column D equals quot;completedquot; the whole row will be
highlighted. Change D to the column you want.

quot;mangeshquot; wrote:

gt;
gt; I want to highlight entire row automatically with yellow color if i type
gt; quot;completedquot; in a cell of that particular row.
gt;
gt; Could any one help me.
gt;
gt;
gt; --
gt; mangesh
gt;
gt;
gt; ------------------------------------------------------------------------
gt; mangesh's Profile: www.excelforum.com/member.php...foamp;userid=6746
gt; View this thread: www.excelforum.com/showthread...hreadid=522864
gt;
gt;