excel for mac highlight row conditioning formating formula

Excel Highlight Row Conditioning Formating Formula How To Highlight A

Excel Highlight Row Conditioning Formating Formula How To Highlight A

In this article, we will learn how to highlight a row, if any cell in that row contains a specific text or value.

We will highlight row using conditional formatting of course.

The first row need to be selected while applying the conditional formatting.

Example: Highlight Rows That Contain a Specific Text Here I have some data in table.

I want to highlight each row in table that contains the value written in C2.

Copy this range and paste special the format to the entire table.

When you change the value in C2, row containing that value will be highlighted only.

Note that only Columns are frozen using and rows are left relative.

It is because we want to change the lookup row when we copy the conditional formatting and while columns are absolute.

In the end, we get highlighted rows that contain specific text in a cell.

But if you want to check the given text in between of strings then you should use this function.

If SEARCH finds the given text, conditional formatting treats it as TRUE else False.

This will check text and in rows and it will highlight the row only if text and case is matched.

Let me know if you have any doubts regarding this article or any excelvba related topic.

In no event shall the owner of the copyrights, or the authors of the applicationscode be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applicationscode.

Home About Advertise With Us Excel Tips and Tricks Excel Editing Excel Format Newsletter Get latest updates from exceltip in your mail.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

This means that every time you visit this website you will need to enable or disable cookies again.

Excel For Mac Highlight Row Conditioning Formating Formula