Excel Quick Tips - How to highlight a row based on a word using conditional formatting in
Want to know how to highlight a row based on a word being found in a cell using conditional formatting in Excel?
Excel has some default conditional formatting options like highlight cells that contain specific text, but what if you want the whole row to be higlighted?
You need to first select your area you want the rules to apply.
Then go to conditional formatting, new rule, use a formula to determine which cells to format.
Now in the formula box you're going to type:
=SEARCH("word",$A1) greater than 0
Here "word" is whatever word you want to find, SEARCH is not case sensitive and you can use wildcards if needed.
$A1 is wherever your range begins and A would be the column your word is found
and since YouTube doesn't allow greater than, less than symbols I had to spell it out
Don't forget to apply whatever formatting you want to have happen, then hit OK and you should be in business!
#data #analytics #excel #shorts
Follow for Excel tips, tricks and more!
📢 NEW! Want my FREE Excel Daily Most Ultimate Guide? Grab it here: https://tmbanalytics.com/resources
🫵 Ready to take on the 7 Days to Excel Challenge? 👉 Click here if you dare: https://tmbanalytics.com/courses/7-da...
👉 Connect with me on social!
Linkedin: / mattbrattin
Tiktok: / mattbrattin