How to color cells based on cell value

[Jing-Pan-China]

Hi, I have a question about how to color cells based on cell value in excel. For example, the value 5 is bigger than the value 3, so the cell color with value 5 is brighter than the cell color with value 3.

[Philanoe]

Hi, in fact, coloring a cell based on its value is called conditional formatting. You can find this in the tab 'Home', 'Conditional Formatting' of Excel. In your example, it is one kind of 'Color Scale' : the larger the cell value, the deeper the color.

Conditional formatting is very useful to visualize abnormality, which is a great tool for accounting or data science (namely data clearing). If you have a particual need, do not hesitate to post it here, and we will find a way to make it possible !