Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i set up a calendar in excel? | Excel Discussion (Misc queries) | |||
Where can I find a 2006 Business Calendar template? | Charts and Charting in Excel | |||
Calendar and info for that date | Excel Discussion (Misc queries) | |||
Calendar 13 Periods 4 weeks each | Excel Discussion (Misc queries) | |||
Weekly data into Calendar Weeks | Excel Worksheet Functions |