Follow the steps shown in this video and you will be able to change  Excel background color based on other cell value.

On The start Screen

  • Click on the Excel Sheet
  • Open the workbook where you want to make the changes
  • In current examples, we will set conditional formats
  • We have taken high value of 70 and low value of 55
  • Select the cells to be formatted .
  • In this example we are selecting the cells from B2 to B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to Greater Than to format the high values.
  • In the greater than window delete the value that appears and click on Cell F5 with the high values entered .
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value .
  • Clock Ok . Click Ok again to close the greater than dialog box .
  • You can see the cells greater than value 70 are colored green .
  • Now to color the cells low t value you can apply second conditional formatting rule to the cell .
  • Select the cells to be formatted .
  • In this examples we are selecting the cells from B2-B13
  • In the Styles group click Conditional formatting
  • Hover the mouse on Highlight Cell Rows and then to less Than to format the low values.
  • In the less than window delete the value that appears and click on Cell F6 with the low values entered
  • Click the drop down lists for formats and click Custom format
  • In the format cells window click the Fill tab and then click the color of your choice for the higher value
  • Clock Ok . Click Ok again to close the less than dialog box
  • You can see the cells lesser than value 55 are colored red
  • In case you want to increase or decrease value you just need to change the value of high and low scorer. the changes would be done accordingly .