hi there,

already a while fighting with this, so see if someone can illuminate me

I am trying to set a conditional formating for a range of cells (several rows, one column) which will check if the value in their same row of another column is something, and if they themselves are less than a fixed value on row 2 of their same column

all I am getting is "Invalid procedure call or argument"

in this post I saw that I need to use RC notation... is that true?
http://www.pcreview.co.uk/forums/sho...43&postcount=2

if so why does my formula do not work?
PHP Code: 
 rg.Select
    With rg.FormatConditions
        .Delete
        .Add _
            Type:=xlExpression, _
            Formula1:="=AND(RC" & dFLFC - rg.Column & "=""FC"", RC<Mid(" & dTGTR.Cells(rg.Column).Address & ", 2, Len(" & dTGTR.Cells(rg.Column).Address & ") - 1))"
        With .Item(1)
            .Interior.ColorIndex = 46
            .Font.Bold = True
        End With
    End With 
on de debugger if I print the formula it comes out something like this =AND(RC-22="FC", RC< Mid($AA$2, 2, Len($AA$2) - 1))