Hi Andrew,

Yes, you could do that, via an event-driven macro, but why isn't
conditionally formatting the cells sufficient?

Cheers


"Andreww" wrote in message
oups.com...
Hi - Is this possible. I just want to colour a cell with blue blocks
without having to go and use format cells from menu.

Furthermore can I conditionally format (without going to the menu). For
instance can I say if value of cell A2 is 23 then colour it red else
blue etc.

Thanks

Andrew