Setting a default value for a dynamic cascading validation list in Excel 2010
Fresh3 days ago
Mar 15, 20266258 viewsConfidence Score0%
0%
Problem
I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem. I would like to set up my spreadsheet so that whenever a change is made in a data validation list, all subsequent lists are set to …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Setting a default value for a dynamic cascading validation list in Excel 2010
Low Risk
A nonVBA method I employ for this problem is to apply a CONDITIONAL formatting to the subsequent cells that checks if the current value it holds matches a value in the current INDIRECT() ref range. If NOT, then the cell turns red, or the value disap…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix