See how to use formulas to format cells and entire rows based on the values you specify or based on another cell's value in Excel 2016, 2013, 20. How to create multiple conditions in Excel. For example, you can highlight all cells a certain color if they fall below the yearly average. Conditional formatting lets you format cells in an Excel spreadsheet based on the cells’ content. Conditional formatting didn’t highlight cell E5. Click in the Formula box, and press Ctr+V to paste in the INDEX/MATCH formula.
select ‘use a formula to determine which cells to format’ and then enter the formula. Click at the end of the formula, and type: =”Sun”. Data bars in Excel make it very easy to visualize values in a range of cells. If you are using the example, apply formatting to all of the sales data.