Here is an interesting scenario. When you change the column in the attached sheet, the font colour of the word Test changes blue or red depending on the width of the column. This is not a macro linked to an event, but simply a combination of conditional formatting with a under-rated Info Function called Cell(). How and where you would like to use this is in your hands...I thought I'd post it due to its "trick" nature and interest!

Cheers