Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact

A1VBCode Forums Home    Search    Members    Calendar    Who's On

Welcome Guest ( Login | Register )       Recent Posts    Popular Topics

Home » Classic Visual Basic (VB 6 or earlier) » VBA(Excel, Word, etc...) » Excel Formula?

Excel Formula? Rate Topic Display Mode Topic Options Author Message Steveclark Posted 4/26/2010 5:23:07 AM Forum Newbie Group: Forum Members Last Login: 7/9/2010 6:03:01 AM Posts: 3, Visits: 9 I want to create a formula or a conditional format in Excel that will allow me to examine a date and see if it is 1 year past the current date. And turn the cell Red. Any help is appreciated. ______________________ Buttons and Triangles in cells Post #29208 Newellmyra Posted 4/29/2010 2:54:01 AM Forum Newbie Group: Forum Members Last Login: 4/29/2010 2:43:48 AM Posts: 3, Visits: 1 What you need to do is highlight the cells you want formatted. Then select 'Conditional formatting' from the 'Format' menu. Change your three condition fields to the following:'Cell Value Is' & 'greater than' & '=TODAY()+365'. Make sure the word TODAY is in all capitals. Sometimes Excel will put quotes around the formula, if it does you'll need to delete them. Access Forum Post #29232 « Prev Topic | Next Topic »

Reading This Topic Active Users: 1 (1 guest, 0 members, 0 anonymous members) No members currently viewing this topic. Forum Moderators: Admin, Mod, Mark, Keithuk

Permissions You cannot post new topics. You cannot post topic replies. You cannot post new polls. You cannot post replies to polls. You cannot edit your own topics. You cannot delete your own topics. You cannot edit other topics. You cannot delete other topics. You cannot edit your own posts. You cannot edit other posts. You cannot delete your own posts. You cannot delete other posts. You cannot post events. You cannot edit your own events. You cannot edit other events. You cannot delete your own events. You cannot delete other events. You may send private messages. You cannot send email's. You may read topics. You cannot rate topics. You cannot vote within polls. You cannot upload attachments. You may download attachments. You cannot post HTML code. You cannot edit HTML code. You cannot post IFCode. You cannot post JavaScript. You cannot post EmotIcons. You cannot post or upload images.

Forum Jump...----------------Forum HomeSearchMembers ListCalendarWho's Online---------------- Announcements  |-- Announcements .NET Programming (VB 2010 or earlier)  |-- Visual Basic .NET  |-- ASP.NET  |-- C# Classic Visual Basic (VB 6 or earlier)  |-- General Visual Basic  |-- Database Programming  |-- COM/ActiveX  |-- API  |-- Internet/Communications Programming  |-- VBA(Excel, Word, etc...)  |-- Game Programming General Discussion  |-- Forum Feedback  |-- Member Chat  |-- Introductions All times are GMT -5:00, Time now is 10:57pm