Conditional Formatting For A List Of Partial Matches In Excel!

In this video, we learn how to format cells that partially match a list of criteria.

Related Videos:

#MsExcel #ExcelCampus
00:00 Introduction
01:11 Conditional Formatting Rule
08:14 Apply to Entire Rows
10:04 Maintenance

[tammytoo]

VERY well done! You somehow manage to train in a very informative yet still concise manner. Most either skip many important things in order to be concise, or go on and on in order to not miss anything. You need to bottle that skill and sell it. Take my money!

[donniechen]

These tutorial videos are great! Appreciate your generosity and time for sharing!

[davidoquinn]

THANK YOU SO MUCH for this video. I’ve had this exact issue for a while and now it works! You have a new subscriber!

[wayneedmondson]

Hi Jon. Great video and tips. Just for fun, here is another way to make the Begins With match: =SUM(--(LEFT(A3, 5)=$F$3:$F$5)). Also, this one will make the match if the rule string is anywhere in the target string (case sensitive): =SUM(--ISNUMBER(FIND($F$3:$F$5, A3))). Fun to play with different ways to get the results. Thanks for sharing :)) Thumbs up!!

[shoaibrehman]

I would say good revision for me with full of explanation. Thanks

[growth]

This is good use of conditional formatting

[justinoneill]

SUPER HELPFUL! Thankyou! The next step in this for me is... "How to highlight the rows cell ONLY if it has a value (not empty)"

[Excelambda]

Great Video!!! Also this can be consider if we are looking for patterns anywhere on the cells, not only at the beginning.
=OR(ISNUMBER(SEARCH(b_w, $A3)))
- we create a table D2·:D6 and define a name selecting the colum of the table as b_w

[tomwelt]

Great topic and explanation, Jon. Super explanation for expanding the criteria list.
How about an explanation for applying the conditional formatting when the database is expanded beyond those through row 20? Should be easy!

[darrylmorgan]

Cool Tutorial With Really Great Tips...Thank You Jon :)

[iankr]

Thanks! Great stuff. I like to name ranges where it helps, so I would name that "Begins with" range used in the COUNTIF formula and use its name there, rather than the address. Makes it easier to audit.

[manojdaruka]

Great video. Just to add to this topic Once u have highlighted the rows in yellow, how do you create a pivot table related to those specific yellow color-coded rows? Kindly advise.

[davidscpa]

Your videos are very informative and I also appreciate the enhanced functionality and efficiency PivotPal provides me. I have an Excel question that is unrelated to this presentation. The rotating band that usually appears then the copy commend is initiated does not appear. The broken (dash) lines do appear but are static. This is a very recent manifestation and does not affect functionality. Would you have any suggestions how this irritating situation can be resolved?

[Bradrackas]

Can you perhaps show this partial matching version of the row formatting but integrated with the Excel addin Fuzzylookup tool for the partial match?

[krishnamurthyalwala]

What shall I do if text contains some words instead of begins with

[bobnicholson]

Sir: enjoy your videos greatly...problem I have numbers in a column and want to rank them (first 4 numbers) according to largest 2nd largest and so on down...but I also want to have the first number colored green second one blue and so for the first largest numbers...Any help ...pls advise...Thanks Bob

[davevoisine]

funny, Just today I had a project very similar to your presentation. I used Vlookup and Left function. In my case i wanted to Isolate the rows that were true (delete the others) and only way i got that to work was a little basic VBA to copy rows that were true to another sheet. thanks!

[kp]

Thanks Jon. I've tried to use conditional formatting over a pivot table and some part of the pivot table is not able to apply the rule to. Please help

[gajabathiarjuntg]

Thanks Jon. Which screen recorder are you using?

[moesadr]

What is we only have one column and need to highlight those with the first 5 matching characters?