Скачать или смотреть How to Change Background Color Based on Text in Excel?

How to change background color based on text in excel?

This one is truly for dummies. It’s super easy and it doesn’t even need any formula let along VBA. Just a few clicks will do. This demonstration is shown with Microsoft Excel 2010 and i used excel conditional formatting to solve this problem. Let’s get started.

1.Open the workbook and select the cells you need to change background
2.Click on the conditional formatting function under the home tab
3.Click on new rule
4.Click “Format only cell that contain” and select “Specific text” in the drop down below
5.Now write the text you need to highlight
6.Select background color by clicking format
7.Click on “OK”

Nice. You have changed the background color based on text in Microsoft excel 2010.

#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/5h8MEg

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 Become a member and enjoy exclusive perks while supporting the channel you love!
   / @excel10tutorial