What you're asking for isn't feasible, since there's no way for the macro to store the details of the last change. Setting up some logic to change white to black, black to yellow and yellow to white, in sequence, is easy enough. But not going from white to black, black to either yellow or white. Indeed, it's not at all clear what the criteria are for the final black to yellow to be triggered as an alternative to the black to white.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]