Hi,

You can't do this without a macro, but you could use a helper cell/column to derive the result, e.g.

=IF(A2="y","-active-","active")
HTH