I want to have a drop down list in excel with about 3 options.

which depending on what option is selected will change the colour of all text in that row to grey.

i already have quite a lot of complicated conditional formatting so would like to do this another way

VB seems the way to go, but having never used it i don't know where to start

any advice, i sort of need tog et this done sharpish so i dont really have time order books and stuff

Thanks
Liam Mc

I think you can do this with just excel, type 'drop-down' into the help search thing and there's stuff on it there. Should be easy to do, I also use conditional formatting of the coloured bars for histograms, very handy

Hi Liam

Try recording a few macros of you changing row colours etc.. Then go into VB and have a look at the code - it's pretty easy then!

If you're really desperate, send me the sheet and I'll try and do it for you.

Regards

Wyn

cheers guys, ill try those out