I'm looking for a way to change the format of a cell to match that of another cell.
For instance when I enter the work 'david' in A2, I want it to have the same background as that in a list from A30:A40.
Application:
I have a list of names in cells A30:A40. Each name has a different format (text and background color).
The sheet as a range of dates along the top and a list of activities along the side as well as a list of names at the bottom the task list.
When someone wants to sign up for a task and date, they type their name in the appropriate cell and the correct format is applied to that cell.
I could put in a bunch of conditional format rules but that means when someone adds or changes the list of names, they have to update the rules.
Any suggestions?
For instance when I enter the work 'david' in A2, I want it to have the same background as that in a list from A30:A40.
Application:
I have a list of names in cells A30:A40. Each name has a different format (text and background color).
The sheet as a range of dates along the top and a list of activities along the side as well as a list of names at the bottom the task list.
When someone wants to sign up for a task and date, they type their name in the appropriate cell and the correct format is applied to that cell.
I could put in a bunch of conditional format rules but that means when someone adds or changes the list of names, they have to update the rules.
Any suggestions?
Last edited: