PDA

View Full Version : Solved: Change cell colour if changes made



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

EDGE
07-22-2010, 05:06 AM
Have you tried using the Conditional Formating options?

Blackie50
07-22-2010, 06:07 AM
Ah - didn't think of that - works fine

thanks
Jon