Conditional Format Index Match Result

Highlight the lookup value in Excel

conditional format index match formula result

Would you like to highlight the result of your lookup formula in the data set?

In this tutorial I show you how to conditionally format the result of your Index Match formula (could be another lookup formula as well) inside the original data set.

The tricky part is to get the formula required for conditional formatting correct. Why? It doesn’t have the most intuitive interface. Just remember this:

One reason why your conditional formatting formulas might not work can be due to the wrong usage of the dollar sign for fixing the cell references (i.e. absolute, versus relative referencing).

Watch the steps in this video:

Feel free to Download the Workbook HERE.

Free Excel Download

The new Excel Dashboards course is here!

Now available on Udemy

Visually Effective Excel Dashboards for your reports.
Redeem your coupon for 75% off below.

GET 75% OFF THE COURSE
Free Ebook

Leave A Comment

Share This