Change Autoshape Text font to bold based on other cell value

Hi,

I'm having issues with changing the text style in an autoshape using VBA.

I want the text to become bold if A1 is greater 0, else remain normal.

The text for the autoshape is in cell A1 and the formula in the autoshape is "=A1" and the autoshape is called "Square".

Originally Posted by davesexcel

Try this,

Please Login or Register  to view this content.

This totally worked, thanks so much.