Hi
We have a new function system for our hotel that enables us to merge the data into an excel function sheet for distribution to the relevant departments.
In cell C6 is the field for the type of function (i.e. Conference, Wedding, Wake etc.). There are about ten types in total.
I would like to be able to put a coloured border around the entire sheet (A1:I55) depending on the function in C6?
i.e. conference - light blue, wedding - pink etc.
Thanks in advance
Clive
We have a new function system for our hotel that enables us to merge the data into an excel function sheet for distribution to the relevant departments.
In cell C6 is the field for the type of function (i.e. Conference, Wedding, Wake etc.). There are about ten types in total.
I would like to be able to put a coloured border around the entire sheet (A1:I55) depending on the function in C6?
i.e. conference - light blue, wedding - pink etc.
Thanks in advance
Clive