Some more restrictive format conditionals include...
=AND(E6>"12/31/2001"+0,LEFT(CELL("format",E6))="D")
...which differentiates between "any old number" and a datevalue beyond 2001. Furthermore, it
requires E6 to be formatted to "look" like a date.
This message was edited by Mark W. on 2002-04-04 12:24