Hi all

I know it is possible to program conditional formatting for a spreed sheet
but is there a way to make the cell a two color fill effect???? iv done it with an object like this

Function Rectangle2()
    
    Selection.ShapeRange.Fill.Visible = msoTrue
    Selection.ShapeRange.Fill.ForeColor.SchemeColor = 11
    Selection.ShapeRange.Fill.BackColor.SchemeColor = 13
    Selection.ShapeRange.Fill.TwoColorGradient msoGradientVertical, 1
End Function
but I cant seem to find anything for a cell.

the closest i got was the ordinary color

    Range("C20").Select
    With Selection.Interior
        .ColorIndex = 3
        .Pattern = xlSolid
        .PatternColorIndex = xlAutomatic
    End With
what i need is colors that blend like one cell will be solid green say cell a1
cell b1 would be green to yellow cell c1 would be yellow to green and so on.

any help appriciated
ed