Excel Formulas to Highlight Intersecting Rows and Columns Exact Match!!
Tags: excelformula, conditionalformattin, excelformulas
Published: 2021-04-03 10:51:17

---
title: Excel Formulas to Highlight Intersecting Rows and Columns Exact Match!!
published: true
date: 2021-04-03 04:19:58 UTC
tags: ExcelFormula,Conditionalformattin,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-highlight-intersecting-rows-and-columns-exact-match/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Highlight Row and Column](https://geekexcel.com/wp-content/uploads/2021/04/Highlight-Row-and-Column.png)](https://geekexcel.com/excel-formulas-to-highlight-intersecting-rows-and-columns-exact-match/highlight-row-and-column/#main)<figcaption id="caption-attachment-22785">Highlight Row and Column</figcaption>
## General Formula:

- You can use the following formula to highlight the rows and columns.

**=[OR](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/)([$A1](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)=row\_val,A$1=col\_val)**

## Syntax Explanations:

- **OR** – In Excel, the [**OR function**](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/) helps to test multiple conditions at the same time.
- **Absolute Reference** – The[**Absolute reference**](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/) 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.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges.png)<figcaption id="caption-attachment-22786">Input Ranges</figcaption>

- 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<u>:</u>[ How to Apply the Formula with Conditional Formatting In Excel?](https://geekexcel.com/how-to-apply-formula-with-conditional-formatting/)**
- Finally, it will highlight the result and displayed it as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/04/Result.png)<figcaption id="caption-attachment-22787">Result</figcaption>

## 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](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Highlight Numbers Include Symbols ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-highlight-numbers-include-symbols/)**
- **[Excel Formulas to Highlight Target Percentage with Conditional Formatting](https://geekexcel.com/excel-formulas-to-highlight-target-percentage-with-conditional-formatting/)**