CALENDAR

[lehigh46]

Hi All,

I set up a vertical calendar where column A contains dates expressed
as follows: May 24, 2005.

Column A contains dates for every day for the next 10 years.

How can I have the current date highlighted using conditional
formatting.


Thanks for your help

Tom Snyder



x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

 

[Vasant Nanavati]

Cell Value Is equal to =TODAY()

 

[lehigh46]

Cell Value Is equal to =TODAY()

THANKS, WORKS GREAT


x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 100,000 other groups
x-- Access to over 1.6 Terabytes per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

 

[Guest]

In the conditional formating box, select 'Formula Is'.
Assuming the range of dates starts at C2, highlight the range and enter the
following formula...
=INT(C2)=INT(NOW())
HTH,