Download Excel File: https://ift.tt/32Gp5Wg
In this video learn how to add Excel Conditional Formatting to a Row, a Column and the Interesting Value using three logical formulas, Mixed Cell References and the AND Logical Function.
Reference Videos:
Excel Two Way Lookup with VLOOKUP & MATCH Functions – Excel Magic Trick 1567
Excel Two Way Lookup with INDEX & MATCH Functions – Excel Magic Trick 1568
Excel Intersection Operator, An Excel Party Trick? – Excel Magic Trick 1570
Excel’s Most Silly Formula Ever Using INDEX or INDIRECT? Excel Magic Trick 1571