Excel Forum
Similar Content
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in ...
Custom Threshold Highlighting Trick in Excel
Tutorial: How to highlight data in Excel based on the number you input into a cell and the comparis...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank


See how to create a logical TRUE / FALSE formula for conditional Formatting using the VLOOKUP function and mixed cell references to highlight the rows where sales people have fallen below the quota. This tricks involved an approximate match with VLOOKUP to get the TRUE FALSE formatting applied.





Got a Question? Ask it Here in the Forum.