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