MikeMcCollister
Board Regular
- Joined
- May 6, 2020
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
In my budget spreadsheet I use list data validation in my "type" column. The list options are as follows:
ATM
Deposit
EFT
This is a convenience to allow me to have a pulldown for the options. In the data validation I have the error alert disabled as I also want to allow for check numbers, like 1234 or 3456. This works fine but if a check number is added then a green triangle is visible in the upper left of the cell. I know that I can turn this off in Excel, but this setting is for all spreadsheets in Excel, not only the worksheet or workbook that I want these green triangles to go away.
Is there a way to have a data validation that allows for a pulldown for convenience but still allows for numbers without being considered invalid data?
Thanks,
Mike
ATM
Deposit
EFT
This is a convenience to allow me to have a pulldown for the options. In the data validation I have the error alert disabled as I also want to allow for check numbers, like 1234 or 3456. This works fine but if a check number is added then a green triangle is visible in the upper left of the cell. I know that I can turn this off in Excel, but this setting is for all spreadsheets in Excel, not only the worksheet or workbook that I want these green triangles to go away.
Is there a way to have a data validation that allows for a pulldown for convenience but still allows for numbers without being considered invalid data?
Thanks,
Mike