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 E...
Display Comments (without hunting for them) - Excel 2003
Tutorial: To find options, go to the File menu, then click options, then click advanced and click on...
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 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.