Hope someone here can help, What i would like to do is change the background colour for an entire row based on one cell Which will say 'Yes' or 'No'.

Basically we have 2 sales methods So along with all the other data there is a column that asks if the sales method is direct? I would like it so if they enter yes then it would change the background colour of all the cells in that row to grey.

In fact, what would make if even better is if we could have a drop down list for them to choose Yes or No from rather than type it, but i'm not sure how to do that or if it's possible...

Thanks for your help,


Tim.