Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trunc entire spreadsheet????? | Excel Discussion (Misc queries) | |||
Can I format an entire row based on the value of a single cell? | Excel Discussion (Misc queries) | |||
Conditional formatting applicable to entire column | Excel Worksheet Functions | |||
In Excel, can I shade entire rows based on the value of a single . | Excel Worksheet Functions | |||
Search should highlight entire row in Excell in red | Excel Discussion (Misc queries) |