Thread
:
excel 2002 question ( dates )
View Single Post
15-06-2005, 12:43
#
4
Salu
Inactive
Join Date: Jun 2003
Location: Yorks
Age: 59
Services: VM TV package. VM phone and 200MB internet & slow Tivo
Posts: 2,332
Re: excel 2002 question ( dates )
Quote:
Originally Posted by
Wicked_and_Crazy
=IF(TODAY()<C2,1,2)
where C2 holds the date
1 = true action
2 = false action
That works well if you use conditional formatting....just tried it.
Salu
View Public Profile
Find More Posts by Salu