Wrong Output

[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

 

[Frank Kabel]

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