check boxes that highlight row

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?

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

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" <mangesh_yadav.1pq76b_1117256701.655@excelforum-nospam.com>
wrote in message
news:mangesh_yadav.1pq76b_1117256701.655@excelforum-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
>