Summary
Keywords
Full Transcript
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses 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. ⬇️ Download the workbook here: https://pages.xelplus.com/cond-format-indexmatch-file 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). 🌍 My Online Excel Courses ► https://www.xelplus.com/courses/ Links to related videos: Index Match basics: https://youtu.be/F264FpBDX28 More on Conditional Formatting: https://youtu.be/875eK_x4nyQ ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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! #excel
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
