Hello,
I would like to update my data validation drop downs to combo boxes for easier usability (larger fonts, etc.), but I am a bit stuck because I have one of them configured to rely on the other using an OFFSET MATCH formula. Does anyone know how to get a combo box to evaluate a formula like this? I have attached an example spreadsheet.
Additionally, if there is a way to make the font size larger in the data validation drop downs or make them more user-friendly, that would work too...
I would like to update my data validation drop downs to combo boxes for easier usability (larger fonts, etc.), but I am a bit stuck because I have one of them configured to rely on the other using an OFFSET MATCH formula. Does anyone know how to get a combo box to evaluate a formula like this? I have attached an example spreadsheet.
Additionally, if there is a way to make the font size larger in the data validation drop downs or make them more user-friendly, that would work too...
