Hello. I'm trying to create a leave planner. Could you help me to understand how I apply the same colour fill, as per the same item in the named range 'Leave type', to the cell where I am selecting from the pull down list?
I.e. If I select 'AL - Full Day' from the pull down list in cell C4, I would like the cell to become orange filled as per the same item in the named range. As always, any help is much appreciated.
Regards,
Lee.
Bookmarks