This is one that's bugged me for years. The latest example is: I have a
macro which pastes a column of numbers into my worksheet (target cells can be
general or number it makes no difference) . Programmatically, I apply
conditional formatting to the pasted cells. Most of the time this works but
sometimes, the conditional formatting does not display until I hit F2 on each
cell in turn once the macro has finished. This is not acceptable as this
macro is part of a large Office application and runs automatically. My users
won't take kindly to having to fiddle with the spreadsheet. I do not want to
change the values in my cells, just have Excel format them properly. Surely,
there's a way - other than copy-paste multiplied by 0 - to get this to work?