 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Can you use formulas in conditional formatting or do I think diff.
I have a spreadsheet with names and dates. They want a date to turn color or do something when the date hits 3 years old. So if I did something on 1.1.04 they want it to indicate expired when 1.1.07 hits. Any suggestions would be greatly appreciated. Thanks!!!! Sure... Using Conditional Formatting, assuming date is in A1: Format... Conditional Formatting... Hit Drop down to say Formula is =if(now()-a1>1095,1,0) Click on Format to change to desired result. That should do it. > I have a spreadsheet with names and dates. They want a date to turn > color or do something when the date hits 3 years old. So if I did something > on 1.1.04 they want it to indicate expired when 1.1.07 hits. > Any suggestions would be greatly appreciated. > Thanks!!!! There could be a leap year within that 3-year span (generally), so maybe better to make it: =if(now()-a1>1096,1,0) Hope this helps. Pete > Sure... Using Conditional Formatting, assuming date is in A1: > [quoted text clipped - 9 lines] > > Any suggestions would be greatly appreciated. > > Thanks!!!! AWESOME!!!!!!!!!!!!!! > Sure... Using Conditional Formatting, assuming date is in A1: > [quoted text clipped - 9 lines] > > Any suggestions would be greatly appreciated. > > Thanks!!!! ....... alternative method is to create a RangeName given a value of =EDATE(TODAY(),-36) .......then do a CF of "CellValueIs", "less than or equal to", =YourRangeName Vaya con Dios, Chuck, CABGx3 > I have a spreadsheet with names and dates. They want a date to turn > color or do something when the date hits 3 years old. So if I did something > on 1.1.04 they want it to indicate expired when 1.1.07 hits. > Any suggestions would be greatly appreciated. > Thanks!!!! |
Reply to this Message |
 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.