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
Watch video How to Change Background Color Based on Text in Excel? online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 03 November 2017, don't forget to share it with your friends and acquaintances, it has been viewed on our site 120,43 once and liked it 87 people.