•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Form control drop down list+ color coding
okay so I'm making a drop down list that has permanent arrow in the same cell as my options. now the list has tasks assigned and I want to color code on the basis of done/not done/in progress
I used the index formula but I think the information in the cell is hidden behind the form control box so is the conditional formatting
Does anyone know how to edit text and formatting of the form control box - even if I can make it 'no fill' so the cell formatting is visible
or keep the arrow from data validation command in the same cell?
is there any other way I can achieve the same cell arrow and color coding both?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#AI formula generation techniques
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#no-code spreadsheet solutions
#data visualization tools
#formula generator
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions