Select the table or range where you want to change the background color of cells.Note: The screenshots for this example were captured in Excel 2010, however the buttons, dialogs and settings are the same or nearly the same in Excel 2016 and Excel 2013. Change color of special cells - blanks, with errors, with formulas.Change a cell's color based on its current value (statically) - Once set, the background color will not change no matter how the cell's value changes.Change the background color of cells based on value (dynamically) - The background color will change automatically when the cell value changes.But what if you want to change the background color of all cells with a certain value? Moreover, what if you want the background color to change automatically along with the cell value's changes? Further in this article you will find answers to these questions and learn a couple of useful tips that will help you choose the right method for each particular task.

Also, you will learn how to use Excel formulas to change the color of blank cells or cells with formula errors.Įveryone knows that changing the background color of a single cell or a range of data in Excel is easy as clicking the Fill color button. In this article, you will find two quick ways to change the background color of cells based on value in Excel 2016, 20.