Web Reference: Formulas that are currently returning arrays that are successfully spilling can be referred to as spilled array formulas. Following are some notes to help you understand and use these type of formulas. Feb 24, 2019 · For example, if you have a UNIQUE () function in Cell B3, apply the conditional format to B3, you will see it appears as '$B$3' in the conditional formatting 'Applies to' range. Change that to '$B$3#' and it should dynamically update with the spill range. Apr 9, 2025 · For each of the rules you're going to create to format your spilled array, you'll need to use a formula. So, in the Select A Rule Type area of the New Formatting Rule dialog box, select the final option, "Use A Formula To Determine Which Cells To Format."
YouTube Excerpt: Download Excel File: https://excelisfun.net/files/EMT1721-1724.xlsx Learn how to use Conditional
Net Worth Profile Overview
Formatting Dynamic Spilled Array Formulas Net Worth 2026: Salary, Income & Wealth Net Worth & Biography
Estimated Worth: $64M - $92M
Salary & Income Sources
Career Highlights & Achievements
Assets, Properties & Investments
This section covers known assets, real estate holdings, luxury vehicles, and investment portfolios. Data is compiled from public records, financial disclosures, and verified media reports.
Last Updated: April 11, 2026
Net Worth Outlook & Future Earnings
Disclaimer: Disclaimer: Net Worth estimates are based on publicly available data, media reports, and financial analysis. Actual numbers may vary.