hi,

sorry Colin, forget the formula, it's a bad idea, because there's no recalculation even adding Application.Volatile
but you can execute the macro


--
isabelle

Le 2011-04-29 21:34, Colin Hayes a écrit :

I know where to put the first formula for the conditional formatting element , but I'm not sure how or where to put the Function code.

Could you advise?

Thanks