CALENDAR
 

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

Cell Value Is equal to =TODAY()

--

Vasant

"lehigh46" wrote in message
...
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

on Tue, 24 May 2005 12:46:40 -0400, "Vasant Nanavati" <vasantn *AT*
aol *DOT* com wrote:

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

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,
--
Gary Brown

Please rate this posting if it is helpful to you.


"lehigh46" wrote:

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