search

Philanoe / Excel-Tips

Excel Q&A qnd tips for all people wishing to get more efficient on this tool
0 stars 0 forks source link

How to color cells based on cell value #2

Open Jing-Pan-China opened 2 years ago

Jing-Pan-China commented 2 years ago

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. 1111

Philanoe commented 2 years ago

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 !