Lock formating of list in Cell validation when using

%3CLINGO-SUB%20id%3D%22lingo-sub-1617830%22%20slang%3D%22en-US%22%3ELock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617830%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20that%20has%20coloured%20cells%20and%20text%20and%20I%20would%20like%20this%20to%20pull%20across%20on%20the%20drop%20down.%20Can%20this%20be%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1617830%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617875%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617875%22%20slang%3D%22en-US%22%3ECan%20you%20share%20the%20file%2C%20It%20will%20be%20easy%20to%20understand%20your%20problem.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1617986%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1617986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F159916%22%20target%3D%22_blank%22%3E%40aditya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20find%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1618494%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1618494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774131%22%20target%3D%22_blank%22%3E%40basomers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20if%20it%20solves%20your%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622263%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622263%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F159916%22%20target%3D%22_blank%22%3E%40aditya%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20but%20I%20can't%20see%20how%20anything%20has%20changed.%20See%20attached%20image%2C%20from%20the%20Status%20tab%20this%20is%20my%20list%20location%2C%20but%20its%20not%20bring%20across%20the%20color%20formatting%20still%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%20See%20Image%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1622352%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1622352%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774131%22%20target%3D%22_blank%22%3E%40basomers%3C%2FA%3E%26nbsp%3BYou%20need%20to%20copy%20the%20conditional%20format%20to%20the%20cell%20you%20highlighted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20more%20importantly%2C%20you%20need%20to%20make%20sure%20that%20the%20status%20you%20wish%20to%20format%20equals%20the%20status%20used%20in%20the%20data%20validation.%20For%20instance%2C%20your%20DV%20list%20has%20%22Completed%22%20whereas%20the%20CF%20rule%20checks%20for%20%22Complete%22.%20Another%20inconsistency%20existed%20between%20%22Ongoing%20%22%20(note%3A%20trailing%20space!)%20in%20DV%20and%20%22Ongoing%22%20(note%3A%20no%20trailing%20space!).%20Fixed%20both%20and%20it%20seems%20to%20work.%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1630375%22%20slang%3D%22en-US%22%3ERe%3A%20Lock%20formating%20of%20list%20in%20Cell%20validation%20when%20using%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1630375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F774131%22%20target%3D%22_blank%22%3E%40basomers%3C%2FA%3EJust%20cut%20copy%20paste%20the%20'Dropdown%20Formatted%20Cells'%20into%20your%20required%20columns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a list that has coloured cells and text and I would like this to pull across on the drop down. Can this be done.

6 Replies
Highlighted
Can you share the file, It will be easy to understand your problem.
Highlighted

@aditya 

 

Thank you find attached.

 

 

 

Highlighted

@basomers 

 

Check if it solves your problem.

Highlighted

@aditya 

Thanks but I can't see how anything has changed. See attached image, from the Status tab this is my list location, but its not bring across the color formatting still See Image

 

Is there a way?

Highlighted

@basomers You need to copy the conditional format to the cell you highlighted.

 

But, more importantly, you need to make sure that the status you wish to format equals the status used in the data validation. For instance, your DV list has "Completed" whereas the CF rule checks for "Complete". Another inconsistency existed between "Ongoing " (note: trailing space!) in DV and "Ongoing" (note: no trailing space!). Fixed both and it seems to work. See attached.

Highlighted

@basomersJust cut copy paste the 'Dropdown Formatted Cells' into your required columns.