-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
fill colour
- Thread starter tonyg
- Start date
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
=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
Upvote
0
