Hi,

when I want to get the operator from a conditional format in Excell
the formula returns a:

"1" for "between
"5" for greather than
...

The formula I use is

Cells(Row, 2) = Cell.FormatConditions(1).Operator

with

Cell As Range

Is this a wrong declaration or do I have to change something else in m
formula.

Thanks
Steve

--
Steven E
-----------------------------------------------------------------------
Steven E.'s Profile: http://www.excelforum.com/member.php...fo&userid=1512
View this thread: http://www.excelforum.com/showthread.php?threadid=26845