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.
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
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.