How to Change Background Color Based on Cell Value in Excel?
Автор: Excel 10 tutorial
Загружено: 2017-11-02
Просмотров: 26323
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: