Hi all,I need to know how to use Event Change to Change Color of Row according
to changing in specified Column cells.for example:I have column S any cell in
it take code A,B,C,D,R W.I need when any cell change in the column S taken
one of the previous 6 codes, then the Row of it change to
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count = 1 And Target.Column = 19 Then
Range(a Target.Row).Interior.Color = RGB(192, 192, 192)
Range(b Target.Row).Interior.Color = RGB(192, 192, 192)
Range(d Target.Row).Interior.Color = vbYellow
Range(c Target.Row).Interior.Color
Please Read this Article
http://www.cpearson.com/excel/Events.aspx
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ahmed galal
Sent: Sunday, July 03, 2011 5:46 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ How to use Event Change to
try using conditional formatting.
On Sun, Jul 3, 201r1 at 5:45 PM, Ahmed galal ahmed.ga...@live.com wrote:
Hi all,
I need to know how to use Event Change to Change Color of Row according to
changing in specified Column cells.
for example:
I have column S any cell in it take code A,B,C,D,R
Thanks ashish for code it helped me a lotnow i developed the code to be:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 19 And Target.Count = 1 Then
Select Case Target.ValueCase ATarget.EntireRow.Interior.Color = RGB(192, 192,
192)Case CTarget.EntireRow.Interior.Color =