Conditional Formatting Drop-Down List

%3CLINGO-SUB%20id%3D%22lingo-sub-1658810%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Drop-Down%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1658810%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20selecting%20an%20option%20from%20a%20drop-down%20list%2C%20can%20conditional%20formatting%20be%20applied%20to%20the%20cell%20and%20change%20color%20based%20on%20the%20selected%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1658810%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

When selecting an option from a drop-down list, can conditional formatting be applied to the cell and change color based on the selected data?

2 Replies
Highlighted

@Jamie-NA2101 

Yes, but you'd have to create a separate rule for each individual value in the dropdown list.

Writing VBA code to color the cell might be more efficient.

Highlighted

@Jamie-NA2101 

 

You can achieve a spectrum of colour with a single CF if that is what you require.

 
 

image.png