Excel Magic Trick 1509: Conditional Format Array Formula to Highlight Row With 2 Lookup Values

Download Files:
https://ift.tt/2zTfxwK
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs

In this video see how to color a row with conditional formatting using an Array Formula & the MATCH Function that will lookup Two Lookup Values in a corresponding Table.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.