Data Validation (Custom)

[Mrtreasurer]

Hi Everyone,

Can a custom data validation be made to allow "Closed" or input a currency. I need to be able to select the Closed option in the list data validation if in fact we were closed, but if the snack shack was open I need to be able to enter a currency of the days takings.

TIA

 

[etaf]

turn off the error alert tab in data validation and then you can enter any value or choose from the list