Blackie50
07-22-2010, 04:36 AM
Hi
I have cells B6 to B10 coloured yellow and if the contents change (just words) I wanted to change to white i.e. remove the colour.
Can't seem to get the worksheet change routine to do it independently for each cell.
Any help appreciated
thanks
Jon
I have cells B6 to B10 coloured yellow and if the contents change (just words) I wanted to change to white i.e. remove the colour.
Can't seem to get the worksheet change routine to do it independently for each cell.
Any help appreciated
thanks
Jon