I am trying to set a row’s background colour, depending on the text content of that particular row.
If row 1 contains the text RGB(10,20,30), I would like that particular row to have that background colour.
I have the following code, but it is slightly wrong somewhere?
Could anyone tell me where I have gone wrong?
Dim v As String
Dim v2 As Variant
if column = 0 then
v = me.cell(row,0)
v2 = "&c" + Hex(Val(v))
g.ForeColor = v2.ColorValue
g.fillrect(0,0, g.Width, g.Height)