Row hight Conditionaly

maftoun

New Member
Joined
Apr 28, 2009
Messages
22
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-com:eek:ffice:eek:ffice" /><o:p> </o:p>
Thanks
 

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Without a screenshot, I'm still confused, but this is my best guess.
Code:
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

maftoun

New Member
Joined
Apr 28, 2009
Messages
22
Hi Lenze

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

Thans
 

Watch MrExcel Video

Forum statistics

Threads
1,108,933
Messages
5,525,693
Members
409,660
Latest member
1817538628

This Week's Hot Topics

Top