Shape as a button to replace a Command Button which operates conditional format.

Hi A440,

Add the shape (Insert really) onto the worksheet and assign the macro to it that the command button is now triggering. Then Cut the command button off the sheet and that should do what you want.