Wrong Output

S

Steven E.

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 it possible to let the formula returning text instead of a number?
Is this a wrong declaration or do I have to change something else in m
formula.

Thanks
Steve
 
F

Frank Kabel

Hi
you have to do this mapping on your own. Excel internally stores
numeric values
 
Top