you cant.

only changing the formula (e.g. the value) if a cell
will trigger an event. changing formatting cannot be caught.

a workaround is trapping the selection change event..
but you'll have to store the formats in a cache..
then compare the actuals with the cached values when
selection changes.

this will be cumbersome and slow if the user makes large selections.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Starting vba programmer wrote :

Hello

How can if run a function after an user changed the backgroundcolor
of a cell? The function must run with a macro or after leaving the
colored cell.

Thanks