Hello
I have a number of forms in different colour schemes. The content is the same.
What I'd like to do is pick my company name from the drop down list in cell A2 and depending on which company is selected, will change the colours of other cells in the worksheet.
These cells will be empty for now, it's a form which will be completed.
I've tried using various conditional formatting options,but I can't get it work. I'm used to doing If statements where there is something in a cell already, but not for something like this.
thank you
thank you for helping
____________
Pendle
I have a number of forms in different colour schemes. The content is the same.
What I'd like to do is pick my company name from the drop down list in cell A2 and depending on which company is selected, will change the colours of other cells in the worksheet.
These cells will be empty for now, it's a form which will be completed.
I've tried using various conditional formatting options,but I can't get it work. I'm used to doing If statements where there is something in a cell already, but not for something like this.
thank you
thank you for helping
____________
Pendle