Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2008

Tip: Looking for answers? Try searching our database.

Conditional Formatting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trish - 10 Apr 2008 15:43 GMT
I have a date cell that I need to apply conditional formatting to when
the date is now one year later.

Example: A4 contains the date 1/1/2007 and today's date is in cell F2
with the formula [TODAY()]. If cell A4 is one year in the past I'd
like the font to change so I'll know that date is older than one year
from today's date.

Thanks for any help!
Trish
Trish - 10 Apr 2008 17:13 GMT
> I have a date cell that I need to apply conditional formatting to when
> the date is now one year later.
[quoted text clipped - 6 lines]
> Thanks for any help!
> Trish

I figured it out! Thanks anyway.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.