You want to create a validation rule to prevent the user from entering too many seats sold. For now, you will create a validation for the Exercise Equipment values on the FW$3$ worksheet.

Select the range B$4$:D$4$ on the FW$3$ worksheet, create a validation rule to allow decimal values less than or equal to $500000.$ Enter the input message title Sales Data and the input message Enter the sales amount for the respective month. $($including the period$).$ Use the Warning alert with the error alert title Potentially Invalid Data and the error alert message The projected maximum is $$500,000.$ However, if actual sales are higher, enter the actual value. $($including the period$).$ Test the data validation by attempting to enter $600000$ in cell D$4$ and click or press Yes. Use the Data Validation arrow to circle invalid data.