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.
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.