hilighting entire row
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 |
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" 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 |
hilighting entire row
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 |
All times are GMT +1. The time now is 12:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com