How to Create a Crosshair Lookup in Excel

In this video, you learn how to create a crosshair lookup pattern in Excel using conditional formatting. #spreadsheetlife #exceltutorial

PRACTICE FILE
Download the practice file used in the video.
https://1drv.ms/x/s!AuGRyDjDT6gJvTqo5...
Go to File - Save As - Download a Copy

RESOURCES
Spreadsheet Templates: https://spreadsheetlife.com/spreadshe...
The Spreadsheet Life Blog: https://spreadsheetlife.com/blog/

LEARN EXCEL OR GOOGLE SHEETS
https://spreadsheetlife.com/all-courses/

VIDEO CHAPTERS
00:00 - Intro
00:18 - Create the Dropdown Lists
01:32 - Create the Horizontal Highlight
02:55 - Create the Vertical Highlight
04:22 - Create the Intersection Highlight
06:02 - Outro