Question

in excel change of colour when the value of the cell increase and decrease

Answer 1

Start with selecting the cells the background color of which you want to change. Create a new formatting rule by clicking Conditional Formatting > New Rule… on the Home tab. Instead of C2, you enter a cell that contains the value you want to check in your table and put the number you need instead of 4.