I want to put a check box on the left side of my sheet and when the user
clicks it, it would high light the row. I got it to work once..though i
dont know how, and i cant get it to do it again. I used conditional
formatting and use the cell value=true condition to do it. But now its
not working at all.... any ideas?


--
static69
------------------------------------------------------------------------
static69's Profile: http://www.excelforum.com/member.php...o&userid=11075
View this thread: http://www.excelforum.com/showthread...hreadid=374756

Select a check-box from the forms menu. Link cell A1 to this checkbox.
Select the entire row you want to highlight. Go to Format Conditional
formatting. Select 'formula is'. And enter the following formula in it:
=$A$1=TRUE
Click format button, and select the required color in patterns tab.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374756

Another approach

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo ws_exit:
Application.EnableEvents = False
With Target
If .Column = 1 Then
If .Value = "a" Then
.Value = ""
.EntireRow.Interior.ColorIndex = xlColorIndexNone
Else
.Font.Name = "Marlett"
.Value = "a"
.EntireRow.Interior.ColorIndex = 35
End If
.Offset(0, 1).Activate
End If
End With

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.





--
HTH

Bob Phillips

"mangesh_yadav"
wrote in message
news:mangesh_yadav.1pq76b_1117256701.655@excelforu m-nospam.com...

Select a check-box from the forms menu. Link cell A1 to this checkbox.
Select the entire row you want to highlight. Go to Format Conditional
formatting. Select 'formula is'. And enter the following formula in it:
=$A$1=TRUE
Click format button, and select the required color in patterns tab.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile:
http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374756