HomeХобби и стильRelated VideosMore From: pc shastra

Highlight Text Values with Conditional Formatting - Excel

29 ratings | 24863 views
Excel Conditional Formatting: - Highlight text values or specific word with the help of conditional format. This will help you to highlight text we can change the rule to test for specific values, dates, blanks, and errors. conditional formatting option can be a great way to build a custom highlighting feature in your worksheet. 👉For more visit my channel PC Shastra - https://www.youtube.com/pcshastra 👉Some Helpful Videos of Excel ▶ Change Case of Text in Microsoft Excel - https://www.youtube.com/watch?v=H46AuBRa7uU ▶ Excel VBA - Autofit Cell Content - https://www.youtube.com/watch?v=wr13wG7ATkc ▶ Insert Picture into an Excel Cell - https://www.youtube.com/watch?v=BKzecTNRk3E ▶ How to Apply, Create & Merge Cell Styles - Excel - https://www.youtube.com/watch?v=M8nwKUesmIk ▶ Filter or Copy Unique Records Only - Excel - https://www.youtube.com/watch?v=xrj6HchZa_M ▶ Data Validation #Dependent Drop Down Lists in Excel - https://www.youtube.com/watch?v=YOvFfYLhf44 ▶ Excel Data Validation #Prevent Entries After Certain Amount - https://www.youtube.com/watch?v=MI5G126YCFg ▶ Excel VBA #Change Font and Background Color of Cells - https://www.youtube.com/watch?v=lLFbKsGXMEE ▶ Use of COUNTIF with Multiple Criteria - Excel - https://www.youtube.com/watch?v=TRTSHUk-yqA ▶ Data Validation #Prevent Duplicate Entries in Excel - https://www.youtube.com/watch?v=Xa-8N_6ZHkg ▶ Copy Format with Auto Fill Handle in Excel - https://www.youtube.com/watch?v=u0_0dOVJ4yg ▶ Apply Superscript & Subscript in Excel - https://www.youtube.com/watch?v=FzxsNLq3VCA ▶ Excel Conditional Formatting #Highlight a Cell with an Entry - https://www.youtube.com/watch?v=b27XWHuEjc4 ▶ Excel VBA Message Box #How to Create MsgBox - https://www.youtube.com/watch?v=HmwoGOtyguI ▶ How to Split Full Name to First and Last Name in Excel - https://www.youtube.com/watch?v=x8arTJeM6XU ▶ How to Hide/Unhide Worksheet and Cell Contents in Excel - https://www.youtube.com/watch?v=cP3pA_DZil8 ▶ Conditional Formatting #Apply Color on Every Other Row or Column - https://www.youtube.com/watch?v=iqXOpAugEOQ ▶ Excel VBA #Select a Cell & Write Value into it - https://www.youtube.com/watch?v=q3IIhScGSOY ▶ Protect Different Ranges with Different Password in a Worksheet - https://www.youtube.com/watch?v=9vxG7n8tIEk ▶ How to Hide and Protect Formulas - Excel - https://www.youtube.com/watch?v=QY736zSjwI0 ▶ Excel Conditional Formatting #Use of Isblank Function - https://www.youtube.com/watch?v=LK6oJmu72Vs ▶ Excel Conditional Formatting Based on Another Cell - https://www.youtube.com/watch?v=09sEq9itE9w ▶ Protect Selected Cells #Type on Specific Area - Excel - https://www.youtube.com/watch?v=dYz5vPf4WGY ▶ Protect Data from Copying in Excel - https://www.youtube.com/watch?v=VILPcJAXWR8 ▶ Sort Data Horizontally in Excel - https://www.youtube.com/watch?v=oypnMBiSdhw ▶ Shortcut Key for Data Validation Dialog Box in Excel - https://www.youtube.com/watch?v=onH6BZFlvb8 ▶ Tricks for Custom Number Format in Excel (Must watch) - https://www.youtube.com/watch?v=5iGF0Fe5GNM ▶ Fill Colors, Patterns and Gradients to Cells in Excel - https://www.youtube.com/watch?v=hiT0s41wNjA ▶ Shortcut for Custom Sort in Excel - https://www.youtube.com/watch?v=diHAkQrEHfw ▶ Insert, Design and Remove a Table without losing Data in Excel - https://www.youtube.com/watch?v=MuW4pPfaNQk ▶ Paste as a Picture Link in Excel 2010 - https://www.youtube.com/watch?v=nN_HFOAjT1k ▶ Repeat Rows and Columns as Titles on Every Printed Pages in Excel - https://www.youtube.com/watch?v=BzBI0ibb8dk ▶ How to Paste Horizontal to Vertical and Vertical to Horizontal in Excel - https://www.youtube.com/watch?v=B-Vm4g0DTYg ▶ Freeze or Lock Row and Column Separately or Together in Excel - https://www.youtube.com/watch?v=orEj68Mt5h8 ▶ How to Apply or Remove Filter with Keyboard in Excel - https://www.youtube.com/watch?v=zfVh1Nn0Ovs
Html code for embedding videos on your blog
Text Comments (3)
Shaukat Samad (2 months ago)
Hi, great excellent teaching , I hope in future u ll teach us more important lesson to improve our knowledge n stand with others !!!!!!
Gregory Heidt (4 months ago)
What if you wanted to highlight the whole row too?
Gopala Krishna (2 years ago)
Every video is improving and user friendly. Please upload some more videos which are helpful for the Excel learners/users/lovers.

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.