How to Change Background Color Based on Text in Excel?
117 هزار بار بازدید -
7 سال پیش
-
How to change background color
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: Patreon: 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
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: Patreon: 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
7 سال پیش
در تاریخ 1396/08/12 منتشر شده
است.
117,088
بـار بازدید شده