How to edit the color of the cell?

[idnoidno]

If mar(i, 7) = "" Then mar(i, 7) = .Cells(1, 5)
End If


If mar (i, 7) = .Cells (1, 5), how to let mar (i, 7) cell color become red?

[mdmackillop]

mar(i,7) is not a cell but an array member.

[SamT]

What's a mar?


Sheets("Sheet1").Cells(13, 7).Interior.ColorIndex = 3

[idnoidno]

The mar is a array.


If mar(i, 8) = "" Then
mar(i, 8) = .Cells(1, 6)
.Cells(i , 8).Font.Color = vbRed
End If


It works but is it correct?:think:

[SamT]

If it works, then it is correct