Row hight Conditionaly

[maftoun]

I have report and actual date of a transaction. I want row auto highlight when I enter actual date of transaction, and get off when I enter repot date of transaction. Could you please help me?
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Thanks

 

[lenze]

Without a screenshot, I'm still confused, but this is my best guess.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
Select Case Target.Column
Case 3
   Application.EnableEvents = False
   Cells(Target.Row, "A") = "Pending"
   Cells(Target.Row, "A").Interior.ColrIndex = 6
   Applcation.EnableEvents = True
Case 1
   If IsDate(Target) Then Target.Interior.ColorIndex = xlNone
Case Else:
End Select
End Sub

lenze

 

[maftoun]

Hi Lenze

I cannot to insert screen shoot. Thanks. on developer view there are few pages where in have to put your code

Thans