I want to change the macro below so that it can change the color of the part of the row, depending on the cell, if not in cell E2 If the value of "proof" is, the cells A2-E2 becomes red.
sub-change color () lRow = range ("E" and rows.Count). (XlUp). For each cell in the row set MR = range ("E2: E" and lRow) if cell.Value = "proof" then cell.Interior.ColorIndex = 3 Next End Sub
the sub change changer (lRow = range ("E")
And rows), replace cell.Interior.ColorIndex = 3
for a specific category. .ft.). (XLEP). For each cell in the row set MR = range ("E2: E" and LRO), if cell.Value = "proof" then the category ("a" & cell.ro & amp; ": E" & amp; ; Cell.ro). External Caller index = 3 next end sub
No comments:
Post a Comment