Support for Office 2003 has ended
Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.
=$D$1To use the value of a defined name, such as "CritVar", type thefollowing formula in the criteria cell:
=CritVarTo use the operators, such as less than (<) and greater than (>), theoperator must be concatenated with the formula. For example, tospecify a match of greater than the value in cell D1, type thefollowing formula in the criteria cell:
=">"&$D$1To specify a match of greater than or equal to a cell defined as"GVAR", type the following formula in the criteria cell:
Article ID: 61090 - Last Review: 11/23/2006 00:59:36 - Revision: 3.0