Conditional Formatting of A Column With Cell Value Change in Row

ootkhopdi

Board Regular
Joined
Sep 30, 2013
Messages
68
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Hello,

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

Is that right or not ...?
 
Upvote 0
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
 
Last edited:
Upvote 0
Hello,

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

Code:
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,213,517
Messages
6,114,085
Members
448,548
Latest member
harryls

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top