Dynamic SaaS Pricing Model Spreadsheet Generator

Create a Python script using pandas and openpyxl that dynamically generates a comprehensive SaaS pricing model spreadsheet. The script should automatically calculate tiered pricing structures, calculate potential revenue projections, and include sensitivity analysis for different customer acquisition scenarios. Include conditional formatting to highlight key metrics and create multiple worksheet tabs for different pricing scenarios, with built-in data validation and error checking.