Some change in vba code [Closed]

Report
Posts
1
Registration date
Tuesday June 9, 2015
Status
Member
Last seen
June 9, 2015
-
Hello,
Here is my code that change column color base on another cell color, i want a that change row cell color with Yes value base on another cell color.
Please help me ASAP.

Sub ChangeColor()
lRow = Range("m" & Rows.Count).End(xlUp).Row
Set MR = Range("m2:m" & lRow)
For Each cell In MR
If cell.Value = "Yes" Then cell.Interior.ColorIndex = Range("G2").Interior.ColorIndex
If cell.Value = "No" Then cell.Interior.ColorIndex = I2
Next
End Sub

i want to code will change color in row form "M2 to AC3" and will be new cell color for new row like "G2" to "G3" in In "M2 to AC3" row.
Thanks

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!