Premium Only Content

Excel Conditional Formatting the Lookup result in data table (Index Match)
Jan 18, 2018 Excel Advanced Formulas & Features
Find out how you can highlight values inside your data set based on a condition. In this example, we are going to conditionally format the result of our lookup formula (I use INDEX Match here) to conditionally format that same value that we find inside the original data set.
The tricky part is to get the conditional formatting formula correct. Just remember, 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 - and sometimes you need a mix of the two).
Download the workbook here:
http://www.xelplus.com/conditional-format-index-match-result/
Links to related videos:
Index Match basics: https://youtu.be/F264FpBDX28
More on Conditional Formatting: https://youtu.be/875eK_x4nyQ
★ My Online Excel Courses ► https://courses.xelplus.com/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
Barry Cunningham
7 hours agoMUST SEE: KAROLINE LEAVITT HOSTS WHITE HOUSE PRESS CONFERENCE ( AND MORE NEWS)
1,850 watching -
53:03
Sean Unpaved
3 hours agoSchlereth Unplugged: 3x Champ Talks TV, Football, & 2025 Season Expectations
14.9K -
1:03:28
Russell Brand
3 hours agoCan You Really Take an Unbiased Look at Hitler? - SF624
96.6K70 -
12:39
Michael Button
5 hours ago $0.05 earnedAn Entire Civilization Might Be Buried Under the Sahara
3323 -
4:38
Michael Heaver
11 hours agoShifting UK Triggers Rapid REVOLUTION
2301 -
58:53
The White House
3 hours agoPress Secretary Karoline Leavitt Briefs Members of the Media, July 31, 2025
11.1K30 -
5:48:07
JuicyJohns
7 hours ago $2.81 earned🟢#1 REBIRTH PLAYER 10.2+ KD🟢$500 GIVEAWAY SATURDAY!
63.1K3 -
LIVE
IrishBreakdown
2 hours agoNotre Dame Fall Camp Practice Report
68 watching -
1:04:08
Timcast
3 hours agoPelosi MELTS DOWN After Trump Accuses Her Of INSIDER TADING, PELOSI ACT Moves Forward
133K83 -
1:54:53
Steven Crowder
6 hours ago🔴 Is the Sig Sauer P320 Killing People & Trump Wins the Trade War: Guest Brandon Herrera
294K238