PeterBoots
New member
Hi,
I've setup a simple spreadsheet to organise volunteers when they are on duty.
I've created a named range which contains all the volunteers.
I've created a picklist to select the volunteers from the named range.
I'd like to be able highlight in a colour if the volunteer has been selected from the named range, so I can see who I may have omitted to select from the named range.
So in this case, I'd like to see Volunteer3 highlighted in a different background or text colour to show that I haven't picked them
I've setup a simple spreadsheet to organise volunteers when they are on duty.
I've created a named range which contains all the volunteers.
I've created a picklist to select the volunteers from the named range.
I'd like to be able highlight in a colour if the volunteer has been selected from the named range, so I can see who I may have omitted to select from the named range.
So in this case, I'd like to see Volunteer3 highlighted in a different background or text colour to show that I haven't picked them
Volunteer ROSTER | ||
Day | Date | Help |
WEDNESDAY | 3-May | Volunteer1 |
THURSDAY | 4-May | Volunteer2 |
WEDNESDAY | 10-May | Volunteer2 |
Volunteer1 | ||
Volunteer2 | ||
Volunteer3 |