How to Change Background Color Based on Cell Value in Excel?

Описание: How to change background color based on cell value in excel?

This tutorial is for beginners and we will be using excel conditional formatting to solve this problem. Remember, I am using excel 2010 for the demonstration. This tutorial is very easy and quick. No need to memorize any formulas for this one. You won’t need VBA code either. Just a few clicks will do the job. Let’s get started.

Well, you opened the workbook already right? If not, then do that and follow the instructions below.

1. Click on Home Tab
2. Click on conditional formatting
3. Click New Rule
4. Now select “Format cells that contain”
5. Fill the value range
6. Click on format and select the fill color.
7. Click OK and see the result

You just changed the background color based on cell value in excel.
#excel10tutorial #excelbackgroundcolor
-------------------------------------------------------------------------------------------------------------
Support Us:   / excel10tutorial  
-------------------------------------------------------------------------------------------------------------

If you like this tutorial, please subscribe: https://goo.gl/uL8fqQ

Get the excel tutorial in PDF version here:
https://goo.gl/m7f9Xs

Checkout our Advance Excel Tutorial Playlist: https://goo.gl/ExYy7v

Checkout the Excel tutorial for dummies playlist: https://goo.gl/UDrDcA

If you need any specific tutorial you can request that here: https://goo.gl/jM78fA

Connect us on social media
Facebook: https://goo.gl/hdJ7rN
Google Plus: https://goo.gl/Yk4DQc

Finally, thumbs up means a lot. So give one. Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial