View Full Version : [SOLVED] Colour cell based on dropdown list

03-24-2015, 07:22 AM
Hi all

I have names in the range B4 to D100 and G4 to G100 like say David Smith and a dropdown list in G1 of all of the names.

What I would like to achieve is that when I select one of these names using the dropdown in G1 that the cells for that person are coloured a light pastel green colour and if there is not a name selected in G1 then the colour reverts to a clear fill.

I hope that this makes sense and as ever your help is most appreciated

03-25-2015, 07:28 AM
Any way to achieve the end product of highlighting cells with the same name in would be fine