Help with conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1925403%22%20slang%3D%22en-US%22%3EHelp%20with%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1925403%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI'm%20looking%20for%20help%20with%20a%20conditional%20formatting%20issue.%26nbsp%3B%20I%20want%20to%20shade%20cells%20a%20different%20colour%20according%20to%20the%20value%20selected%20from%20a%20drop-down%20list%20(there%20are%20four%20options%2C%20so%20I%20need%20a%20rule%20that%20dictates%20which%20colour%20to%20shade%20the%20cell%20based%20on%20the%20option%20chosen).%26nbsp%3B%20I%20can't%20find%20anything%20in%20the%20online%20help.%26nbsp%3B%20Can%20anyone%20here%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1925403%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1925442%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1925442%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F879336%22%20target%3D%22_blank%22%3E%40NicolePayne%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou'll%20have%20to%20create%20four%20different%20rules%2C%20one%20for%20each%20drop-down%20option.%3C%2FP%3E%0A%3CP%3ESelect%20the%20cells%20that%20have%20the%20drop-down.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EOn%20the%20Home%20tab%20of%20the%20ribbon%2C%20select%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3C%2FLI%3E%0A%3CLI%3ESelect%20'Format%20only%20cells%20that%20contain'.%3C%2FLI%3E%0A%3CLI%3ELeave%20the%20first%20drop-down%20set%20to%20'Cell%20Value'.%3C%2FLI%3E%0A%3CLI%3ESelect%20'equal%20to'%20from%20the%20second%20drop-down.%3C%2FLI%3E%0A%3CLI%3EEnter%20the%20first%20option%20in%20the%20box%20next%20to%20it.%3C%2FLI%3E%0A%3CLI%3EClick%20Format...%3C%2FLI%3E%0A%3CLI%3EActivate%20the%20Fill%20tab.%3C%2FLI%3E%0A%3CLI%3ESelect%20a%20color.%3C%2FLI%3E%0A%3CLI%3EClick%20OK%2C%20then%20click%20OK%20again.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3ERepeat%20the%20above%20steps%20with%20the%20second%20option%20and%20a%20different%20color.%3C%2FP%3E%0A%3CP%3ESame%20for%20the%20third%20and%20fourth%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi all,

I'm looking for help with a conditional formatting issue.  I want to shade cells a different colour according to the value selected from a drop-down list (there are four options, so I need a rule that dictates which colour to shade the cell based on the option chosen).  I can't find anything in the online help.  Can anyone here help?

2 Replies

@NicolePayne 

You'll have to create four different rules, one for each drop-down option.

Select the cells that have the drop-down.

  • On the Home tab of the ribbon, select Conditional Formatting > New Rule...
  • Select 'Format only cells that contain'.
  • Leave the first drop-down set to 'Cell Value'.
  • Select 'equal to' from the second drop-down.
  • Enter the first option in the box next to it.
  • Click Format...
  • Activate the Fill tab.
  • Select a color.
  • Click OK, then click OK again.

Repeat the above steps with the second option and a different color.

Same for the third and fourth option.

Thanks!