Google Sheet Advance Set Up

Need help with setting up google sheet for inventory - management, notifications and reporting. Sheet includes multiple tabs, formulas, conditional formatting, dashboard tab.
Missing: Conditional formatting on dashboard tab based on information in other tabs and notifications to be emailed based on low inventory.