Conditional Formatting is a powerful function that allows you to highlight the whole row and columns based on a certain condition. This tutorial will show how to highlight the intersecting rows and columns with conditional formatting based on exact match. Let’s see them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
General Formula:
- You can use the following formula to highlight the rows and columns.
Syntax Explanations:
- OR – In Excel, the OR function helps to test multiple conditions at the same time.
- Absolute Reference – TheAbsolute reference is an actual fixed location in a worksheet.
- Row_Value – It represents the row value from your worksheet.
- Column_Value – It represents the column value from your worksheet.
- A1 – It represents the input values from your worksheet.
- Criteria – It specified the criteria value.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example image.
- Here we will enter the input values in Column B to Column E.
- Now we are going to highlight the values based on the given criteria.
- So apply the above-given formula in the conditional formatting option.
- To know how to apply conditional formatting in Excel, just refer to this article: How to Apply the Formula with Conditional Formatting In Excel?
- Finally, it will highlight the result and displayed it as shown below.
Wind-Up:
Here, we have described the simple formula used to highlight the intersecting rows and columns in Excel. Hope you like this article!! Please feel free to state your query or feedback for the above article. Thank you for visiting our site!! To learn more, check out Geek Excel *and Excel Formulas *!!
Top comments (0)