Color Coding Symbols in a dropdown list in a table

%3CLINGO-SUB%20id%3D%22lingo-sub-2734667%22%20slang%3D%22en-US%22%3EColor%20Coding%20Symbols%20in%20a%20dropdown%20list%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2734667%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20Color%20Code%20using%20CHAR(117)%20into%20my%20budge%20in%20%22payment%20status%22%20column%20range.%20I%20want%20to%20use%20%22SB%22%20(Submitted)%20with%20color%20being%20Red%2C%20%22PN%22%20(Pending)%20with%20the%20color%20being%20Yellow%20or%20Orange%2C%20%22PD%22%20(Paid)%20using%20the%20color%20Green.%20When%20I%20do%20the%20Data%20Validation%26nbsp%3B%20for%20the%20Dropdown%20I%20get%20the%20symbol%20but%20I%20lose%20the%20color%20of%26nbsp%3B%20CHAR(117).%20I%20have%20tried%20several%20ways%20to%20fix%20the%20issue%20but%20I%20have%20not%20been%20able%20to%20resolve%20the%20Issue.%20ANy%20help%20woul%20be%20apperica%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2734667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736037%22%20slang%3D%22en-US%22%3ERe%3A%20Color%20Coding%20Symbols%20in%20a%20dropdown%20list%20in%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1150476%22%20target%3D%22_blank%22%3E%40Patch1482%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou're%20making%20the%20job%20far%20more%20difficult%20than%20it%20needs%20to%20be%2C%20by%20using%20special%20characters%20(CHAR(117).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel's%20Custom%20Formatting%20is%20made%20for%20the%20kind%20of%20thing%20you're%20trying%20to%20do.%20See%20it%20there%20on%20the%20right%20on%20the%20%26nbsp%3B%22Home%22%20tool%20bar%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_0-1631187120084.png%22%20style%3D%22width%3A%20671px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309229i8924706BEA024DB0%2Fimage-dimensions%2F671x109%3Fv%3Dv2%22%20width%3D%22671%22%20height%3D%22109%22%20role%3D%22button%22%20title%3D%22mathetes_0-1631187120084.png%22%20alt%3D%22mathetes_0-1631187120084.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20set%20up%20these%20rules%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_1-1631187176488.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309230iC2E089EA81114B8D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_1-1631187176488.png%22%20alt%3D%22mathetes_1-1631187176488.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eto%20get%20this%20in%20the%20way%20of%20results%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22mathetes_2-1631187205092.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309231iB6EC194FB2F0EA53%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mathetes_2-1631187205092.png%22%20alt%3D%22mathetes_2-1631187205092.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I am trying to Color Code using CHAR(117) into my budge in "payment status" column range. I want to use "SB" (Submitted) with color being Red, "PN" (Pending) with the color being Yellow or Orange, "PD" (Paid) using the color Green. When I do the Data Validation  for the Dropdown I get the symbol but I lose the color of  CHAR(117). I have tried several ways to fix the issue but I have not been able to resolve the Issue. ANy help woul be apperica

1 Reply

@Patch1482 

 

You're making the job far more difficult than it needs to be, by using special characters (CHAR(117). 

 

Excel's Custom Formatting is made for the kind of thing you're trying to do. See it there on the right on the  "Home" tool bar?

mathetes_0-1631187120084.png

 

I set up these rules

mathetes_1-1631187176488.png

 

to get this in the way of results

mathetes_2-1631187205092.png