Free Excel
|||

How to apply conditional formatting to multiple cells

You want to change the colour of multiple cells based on the cells value then this is how you do it. In the following exercise you will change any number above £50,000 to red.

You can, of course, use conditional formatting to change the colour of a cell based on a numerical value. However you can also change the colour of multiple cells depending on many other factors.

Conditional Formatting based on another cells value

Conditional Formatting Excel

Conditional Formatting

Excel version (2007 - 2016)

  1. Open up a blank workbook and click in Cell A1.
  2. Enter the following information:
    Sales Amount
    Jan 20000
    Feb 30000
    Mar 100000
    Apr 40000
    May 70000
    Jun 20000
  3. Format the numbers as currency. (Just so it looks nice and tidy).
  4. Highlight all of the currency figures.
  5. Click on the Home tab then on Conditional Formatting to the right.
  6. Go down to Highlight Cell Rules then click Greater than.
  7. In the Greater Than box that appears enter 50000 in the greater than box.
    Greater than conditional formatting
  8. Click OK.
  9. Note that all the numbers above £50,000 are now red.