Highlight a row using conditional formatting in Excel

[kurthannahs]

So helpful, been struggling with this for hours. I appreciate you.

[jasonatwood]

I tried different things, searched different things, all trying to figure this out. Then saw your video and BOOM, someone was finally helpful! Thank you!

[dreashirlene]

So extremely helpful, short, sweet to the point. I love it.

[jodebiz]

I did save time at work! it was so clear, straightforward, good pace ...Thank you!

[bgcubingchannel]

I was searching for this "entire row color change" for like 3 days. Thank you!

[IronReel]

The whole "F4" thing is what was throwing me off. Thanks for this!

[alirehman]

So Helpful. Thanks. Very video should be like this. Short and to the point

[ezhilpriya]

perfect explanation.... thank you for this.... been searching for this

[RandoVidz]

If you add a row below the selected, will the function copy down to the new row?

[charlin]

Mine's not working, the row that was highlighed is the one above where I type the word Complete

[JagannathY-fkio]

How can we apply the same conditional formatting automatically to the data that we add daily ?

[dadecounty]

Can you just put a drop down menu that allows you to pick complete, not started etc.

[bingefeller]

thanks. how can i make this happen for a spreadsheet where the number of rows will increase daily? I currently have 1002 rows but this will rise each day.

[hisham]

Thank you!! Shot and Informative!! STRONG SUBSCRIBE!!

[scottpeters]

Double clicking F4 did not do anything, so I entered the formula manually to reflect yours. But mine does not change the color of the column or any cells

[TheNaiqqi]

Does this has any constraint? I'm doing the exact same steps for 120000 rows but nothing happens.

[calystah]

This is great - but what if my answers vary? I have a common word "destroy" but it also includes the number of days that the item has been expired. So each cell is different and I can't get the whole row to highlight.

[mondaymendoza]

What about i want to highlight the whole row if a cell contains specific text but it has other characters in the text string. For example, i want to highlight the whole row if the cell in column c contains the word "dog", but then if i do that formula, it won't accept only "dog" but it has to be "dog park". I only want to highlight the whole row if the cell in column c has the word "dog" in its text string. What is the formula for that? Please help me. Please reply.

[GinaWithTheEyeBank]

I keep getting a format error even when I'm following this step by step. So frustrating!