Excel Quick Tips - How to highlight a row based on a word using conditional formatting in #Excel

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!

📚 Grab my FREE Excel for Professionals Ultimate Guide full of my 100+ of my favorite Shortcuts and Functions:

[bali]

You're fast becoming my favourite excel tips creator. A combination of well-curated highly-useful but less-obvious excel scenarios, additional info such as keyboard shortcuts galore and detailed explanations, all concisely and expertly delivered without fluff but with a to-the-point charm.

[genoteich]

Finally! Looked for this for a long time. Very quick and simple explanation. Thanks!

[Meepbeeped]

This is the only video that helped me, thank you!!! ❤

[stephenarvincatalan]

The only vid that helps me. Massive Thanks Matt!

[hulkamannya]

How would you highlight all the rows that do NOT say "apple"? Thank you.

[liamhancox]

Hi Mine works. Except i have a data input macro that adds a new line. Even i am selecting whole sheet it ignores the new inseted row

[mr.v]

Sir Is it possible to color the found cell current cell. Means if i find with ctrl+f and hit xyz in serch when i hit enter it will turn colored because it seem so difficult to see where is the cell is😅

[Nevarnost]

I'm trying to highlight full rows when a word is found but I can't manage to do this.
I used =SEARCH("word", A1)>0 but it highlights only the single cells. What can i do?

[louisaguiseauthor]

what is a wildcard? it is too small to see what is being typed and the formula isn't working for me

[moldovandorin]

I still don't understand how to do it

[eyal]

"Is there a way to X in excel"?
Yes