Conditional Formatting of A Column With Cell Value Change in Row

[ootkhopdi]

Hi.

I have a database in sheet
I Want to change Colour of Cell A5 and related Cell, if Any Value of Cells A5:Z5 is Changed..
i have a code which changed cell colour , if cell value or cell updated even with F2(Not Data Changed), but i want with this cell , Column A cell is also changed..

like

if Value of Cell E5 is Changed or Updated then Cell A5 and Cell E5 Colour is Changed to yellow or Red..


Please give me solution.


Thanks

 

[James006]

Hello,

From you description, it looks as if you are looking for an event macro ...

Is that right or not ...?

 

[ootkhopdi]

No. I want a simple code..
or
if event macro is a code ,which run after change value, i think it right,,

but i have little knowledge about it, so not confirmed..

please give me aan example for event macro.. so i can understand it,,

thanks

 

[James006]

Hello,

Below is an example for your situation ... :wink:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address <> "$E$5" Then Exit Sub
Target.Interior.Color = vbYellow
Target.Offset(0, -4).Interior.Color = vbYellow
End Sub

HTH

 

[ootkhopdi]

Thanks james..

i want like this.

when value of range A3:BZ3 is changed in any cell like , in a3 or d3 or in z3,,
cell colour of changed cell( a3,d3 or z3) should be change as well as cell a3.
means when a cell of any row is changed then column A and changed cell both highlighted..


thanks

 

[ootkhopdi]

Private Sub Worksheet_Change(ByVal Target As Range)
I Solve the Problem with this code
you can change target colour as you like

"Dim x As Integer
x = Target.Column
If Target.Address <> Target.Address Then Exit Sub
Target.Interior.Color = vbRed
Target.Offset(0, -(x - 1)).Interior.Color = vbYellow
End Sub"

Thanks every one for help me