Home

Cell Validation - Drop Down Lists and Text Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-1030061%22%20slang%3D%22en-US%22%3ECell%20Validation%20-%20Drop%20Down%20Lists%20and%20Text%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030061%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20form%20in%20Excel%20that%20has%20a%20couple%20of%20drop%20down%20list%20options.%20I%20have%20my%20lists%20saved%20on%20a%20separate%20tab%20and%20i%20would%20like%20the%20options%20within%20one%20of%20the%20lists%20to%20repeat%20the%20specific%20text%2Fcell%20formatting%20i%20have%20in%20place%20(each%20option%20has%20a%20different%20colour%20of%20text%20and%20cell%20fill%20applied%2C%20with%26nbsp%3B%20mixed%20font%20sizes%20within%20the%20same%20cell).%26nbsp%3B%3CBR%20%2F%3EIs%20there%20a%20away%20o%20can%20do%20this%20without%20also%20adding%20conditional%20formatting%20to%20the%20cell%20that%20contains%20the%20drop%20down%3F%20CF%20doesn't%20quite%20give%20the%20result%20i%20am%20looking%20for%20as%20it%20doesn't%20mirror%20the%20mixed%20font%20sizing%20i%20have%20in%20place%20for%20the%20actual%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20appreciate%20any%20help%20you%20can%20offer%20with%20this.%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EJ%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1030061%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Edata%20validation%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDrop-Down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormatting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1030325%22%20slang%3D%22en-US%22%3ERe%3A%20Cell%20Validation%20-%20Drop%20Down%20Lists%20and%20Text%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1030325%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20can%20upload%20a%20sample%20file%2C%20that%20will%20make%20it%20easier%20to%20understand%20and%20get%20best%20response%20on%20this%20platform%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi, 

 

I have a form in Excel that has a couple of drop down list options. I have my lists saved on a separate tab and i would like the options within one of the lists to repeat the specific text/cell formatting i have in place (each option has a different colour of text and cell fill applied, with  mixed font sizes within the same cell). 
Is there a away o can do this without also adding conditional formatting to the cell that contains the drop down? CF doesn't quite give the result i am looking for as it doesn't mirror the mixed font sizing i have in place for the actual list.

 

Would appreciate any help you can offer with this. 

Thank you

1 Reply
Highlighted
Hello,

If you can upload a sample file, that will make it easier to understand and get best response on this platform
Related Conversations
Resulting NaN when calculating between two dates
JunHo_KIM in SharePoint on
0 Replies
List column customization
chinmaykulkarni in SharePoint on
1 Replies
How to manage multiple lists
BangorKeith in SharePoint on
2 Replies
Question about the 5000 items threshold
288088 in SharePoint on
3 Replies