"Can I format a cell based on another cell value, and have the formatting update automatically whenever the cell value changes?" Then answer is "yes" and this blog post demonstrates the steps www.excel-university.com/dynamic-conditional-formatting-for-top-3-values/