Macro

[Closed]
Report
Posts
2
Registration date
Wednesday August 17, 2016
Status
Member
Last seen
August 17, 2016
-
Posts
2
Registration date
Wednesday August 17, 2016
Status
Member
Last seen
August 17, 2016
-
Hello, in excel 2013 I have column of cells a:2:a4955 of the cell.interior.colorindex = 3 then
I need to return "red"

I can't get his to work.

1 reply

Posts
2
Registration date
Wednesday August 17, 2016
Status
Member
Last seen
August 17, 2016

Sub What_color ()
Dim Cell as Range
For each cell in range ("a:2:a4955")
If cell.interior.colorIndex = 3
Then cell.value = "red"
Next cell
End sub