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...