In the example above, you are changing the cell color based on that cell value only. Repeat the same process for 11-20 and 21-30, and you’ll see that number changes as per the value of the cell. Now enter the value between 0 and 10 in cell E3, and you will see that cell color changes to blue and if there is any other value or no value then cell color changes to blank. Then, on the first box enter 0 and in the second box enter 10, then click on the Format button and go to Fill Tab, select the blue color, click ok and again click ok. Then select “Format only cells that contain,” then in the first drop down select “ Cell Value” and in the second drop-down select “ Between.” Note: Make sure the cell on which you want to apply conditional formatting is selected. On the Home tab, in the style section group, click on Conditional Formatting -–> New Rule You can achieve this with the help of conditional formatting. Say, you want to color of cell E3 based on values as following.Ġ -10: You want the cell color to be BlueĢ1-30: You want the cell color to be YellowĪny other value or Blank: No color or No Fill. Now, what if you want to change the cell color based on cell value? Suppose, you want that color of cell E3 changes with the change of the value in it. Cell color formatting based on the cell’s value You can refer to this as static formatting of the cell E3. This means that cell color is independent of cell value, so no matter what value is entered in E3, the cell color will always be blue. In the above example, the color of cell E3 has been changed from No Fill to Blue color, and notice that the value in cell E3 is 6 and if you change the value in this cell from 6 to any other value the cell color will not change and it will always remain blue. Basic cell color formattingĭid you know that you can change the background color of cells by going into the formatting of the cell? Then, you can choose the Fill section and select the intended color to fill the cell.
Changing the color of a cell might seem simple enough, but what if you wanted cells to be a particular color based on certain criteria? In these cases, you would use conditional formatting to change your cell’s background color.
0 kommentar(er)
