Cell formating from validated data - colour

%3CLINGO-SUB%20id%3D%22lingo-sub-2562451%22%20slang%3D%22en-US%22%3ECell%20formating%20from%20validated%20data%20-%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562451%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20have%20created%20a%20set%20of%20drop-down%20lists%20-%20the%20data%20in%20the%20table%20is%20coloured%20(for%20certain%20subjects)%20but%20when%20I%20select%20from%20the%20list%20on%20my%20main%20sheet%2C%20the%20cell%20only%20contains%20the%20text%3A%20the%20colour%20formatting%20does%20not%20apply%20to%20the%20cell.%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20would%20you%20advise%20how%20I%20go%20about%20getting%20the%20colour%20of%20the%20cell%20to%20change%20when%20I%20select%20from%20the%20drop-down%20list%3F%3CBR%20%2F%3EThank%20you%20(from%20someone%20slightly%20scared%20of%20Excel!)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2562451%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2562494%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20formating%20from%20validated%20data%20-%20colour%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2562494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1107179%22%20target%3D%22_blank%22%3E%40HHornby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20source%20range%20is%20coloured%20through%20conditional%20formatting%2C%20you%20could%20apply%20the%20same%20rules%20to%20the%20cell(s)%20with%20the%20validation%20drop-down.%3C%2FP%3E%0A%3CP%3EIf%20the%20source%20range%20has%20been%20coloured%20manually%2C%20it%20would%20require%20VBA%20to%20colour%20the%20cell(s)%20with%20the%20drop-down.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello

I have created a set of drop-down lists - the data in the table is coloured (for certain subjects) but when I select from the list on my main sheet, the cell only contains the text: the colour formatting does not apply to the cell. 

Please would you advise how I go about getting the colour of the cell to change when I select from the drop-down list?
Thank you (from someone slightly scared of Excel!)

1 Reply

@HHornby 

If the source range is coloured through conditional formatting, you could apply the same rules to the cell(s) with the validation drop-down.

If the source range has been coloured manually, it would require VBA to colour the cell(s) with the drop-down.