Most people set up a dropdown list to make spreadsheets smarter with Excel's data validation. However, the Custom option in the Data Validation dialog accepts any formula that returns TRUE or FALSE, ...
How-To Geek on MSN
6 simple Excel automations you can do in under 5 minutes
Stop doing more than you have to in Excel—built-in tools can automate repetitive tasks instantly.
一些您可能无法访问的结果已被隐去。
显示无法访问的结果