Excel Forum

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.