How do I link a macro to a button that recalculates average revenue and updates KPI boxes with conditional colors (e.g., green if > 100k)?
| Quarter | Product Line | Revenue (USD) | Cost of Goods Sold (COGS) | Operating Expenses | Net Income |
|---|---|---|---|---|---|
| Q1-2023 | Alpha | 120,000 | 70,000 | 20,000 | 30,000 |
| Q2-2023 | Alpha | 135,000 | 75,000 | 22,000 | 38,000 |
| Q3-2023 | Alpha | 150,000 | 78,000 | 24,000 | 48,000 |
| Q4-2023 | Alpha | 160,000 | 80,000 | 25,000 | 55,000 |
| Q1-2024 | Beta | 90,000 | 45,000 | 18,000 | 27,000 |
| Q2-2024 | Beta | 100,000 | 50,000 | 19,000 | 31,000 |
| Q3-2024 | Beta | 110,000 | 52,000 | 20,000 | 38,000 |
| Q4-2024 | Beta | 120,000 | 55,000 | 21,000 | 44,000 |