Hello,

I'm fighting with the following simple line of code:

Code:
oFormatCondition1 = CType(xlRange.FormatConditions.Add(Type:=Excel.XlFormatConditionType.xlCellValue, Operator:=Excel.XlFormatConditionOperator.xlNotEqual, Formula1:="=RC[-1]"), Excel.FormatCondition)
if I just replace "=RC[-1]" by a numeric value, it's working, but not with this formula!

the condition I want to write is: if this cell value <> the previous cell value (RC[-1])

Can someone help me here ?
Thanks in advance