Instructions to change the cell background color (Cell) in Excel
You have to work with a huge amount of data in Excel, need to highlight the values to compare, use the background color for cells to help you work with numbers easily. The following article shows how to change the cell's cell color in Excel.
1. Change the cell background color simply
- Select a cell to fill with the background -> go to the Home tab -> Fill Color -> select a fill color:
Instructions to change the cell background color (Cell) in Excel Picture 1
- The result has the cell color as shown:
Instructions to change the cell background color (Cell) in Excel Picture 2
- In case you want to remove the background color, click the No Fill button:
Instructions to change the cell background color (Cell) in Excel Picture 3
2. Change the cell background color by value
In case the number of calculations in the table is too large, you need to emphasize special values, use the cell's background color by value.
Step 1: Select the cells that need background color -> Home -> Conditional Formatting -> Manages Rules:
Instructions to change the cell background color (Cell) in Excel Picture 4
Step 2: A dialog box appears and click New Rule:
Instructions to change the cell background color (Cell) in Excel Picture 5
Step 3: Select the type of conditions to color, with the following options:
+ Format all cells based on their values: color the background of all cells based on its values
+ Format only cells that contain: Fill the cell background color according to the value on the cell.
+ Format only top or bottom ranked values: color according to the data area between the first and last value.
+ Format only values that are above or below average: fill the cells with values above or below the average value.
+ Format only unique or duplicate values: color the cells with unique or duplicate values .
+ Use a formula to determine which cells to format: use another formula to color.
Instructions to change the cell background color (Cell) in Excel Picture 6
- For example, here select the color according to the value on the cell -> in Format only cells with click on the arrow to select the type of condition. For example, here is the option to color cells that are larger than the value in E6 -> click Format to select cells and other formats:
Instructions to change the cell background color (Cell) in Excel Picture 7
Step 4: The Format Cell dialog box appears, select a fill color in the Fills tab , and select other cell formats -> OK:
Instructions to change the cell background color (Cell) in Excel Picture 8
Step 5: Click OK to confirm your selection:
Instructions to change the cell background color (Cell) in Excel Picture 9
Step 6: Continue to click OK to confirm:
Instructions to change the cell background color (Cell) in Excel Picture 10
- Result of cells with values greater than the value in cell E6 are colored:
Instructions to change the cell background color (Cell) in Excel Picture 11
In addition, to edit the rules , create a check mark in the Stop If True section and click on the Rule in the Edit Rule option , to clear the Delete Rule option .
Instructions to change the cell background color (Cell) in Excel Picture 12
Above is a detailed guide on how to change the cell's background color (Cell) in Excel 2013, with other versions you manipulate similar . Hope to help you in the process of working with a huge amount of data. Good luck!
You should read it
- Calculate by cell background color in Excel
- How to change spreadsheet color lines in Excel
- How to color the background, table color in Word, Excel
- Ms Excel - Lesson 13: Use conditional formatting in Excel
- How to use conditional formatting in Microsoft Excel 2016
- How to color formula cells in Excel automatically
- How to calculate and color blank cells in Excel
- Complete tutorial of Excel 2016 (Part 5): Basics of cells and ranges
- Change color between different lines in Microsoft Excel
- How to change the SheetTab color and hide the worksheet in Excel
- How to format data based on other cell conditions in Excel
- How to automatically create valuable cell borders in Excel
May be interested
How to draw arrows in Word
How to split columns in Word and tips or handle columns in Word
How to insert tick marks, checkboxes into Word
How to create automatic table of contents in Word 2016
WEIBULL function - The function returns the Weibull distribution in Excel
DAYS360 function - The function finds the number of days between two dates based on a 360-day year in Excel