Guest Ben Posted August 6, 2007 Posted August 6, 2007 For example (lets say all cells have black text): 06 Aug 2007 07 Aug 2007 08 Aug 2007 If today is 06 Aug 2007, nothing happens, all cells have black text. Go to sleep... now its 07 Aug 2007. Is there a way to cross/tick off the previous days automatically with a formula or conditional format? I want to make the text turn to red, eg. in our above example 06 Aug 2007 should now turn red because we are now 07 Aug 2007. Thanks in advance for some replies!! (I hope)
Guest sgopus Posted August 6, 2007 Posted August 6, 2007 RE: Possible to: Tick or cross off dates as they go by? This forum is about xp general questions, if your asking about a spread sheet, then you need to go to the office forum, besides you didn't state what program your using to get these dates, no useful info. "Ben" wrote: > For example (lets say all cells have black text): > 06 Aug 2007 > 07 Aug 2007 > 08 Aug 2007 > > If today is 06 Aug 2007, nothing happens, all cells have black text. Go to > sleep... now its 07 Aug 2007. > > Is there a way to cross/tick off the previous days automatically with a > formula or conditional format? I want to make the text turn to red, eg. in > our above example 06 Aug 2007 should now turn red because we are now 07 Aug > 2007. > > Thanks in advance for some replies!! (I hope) > > >
Guest Gary S. Terhune Posted August 6, 2007 Posted August 6, 2007 Re: Possible to: Tick or cross off dates as they go by? What program are you talking about? This is a WINDOWS XP newsgroup. That said, and presuming you're talking about Excel, my guess is that it can be done with a macro, but don't quote me on that. What you need is an Excel newsgroup. http://news://msnews.microsoft.com/microsoft.public.excel.programming -- Gary S. Terhune MS-MVP Shell/User http://www.grystmill.com "Ben" <bswong@bigpond.net.au> wrote in message news:O9xti.16311$4A1.11252@news-server.bigpond.net.au... > For example (lets say all cells have black text): > 06 Aug 2007 > 07 Aug 2007 > 08 Aug 2007 > > If today is 06 Aug 2007, nothing happens, all cells have black text. Go to > sleep... now its 07 Aug 2007. > > Is there a way to cross/tick off the previous days automatically with a > formula or conditional format? I want to make the text turn to red, eg. in > our above example 06 Aug 2007 should now turn red because we are now 07 > Aug 2007. > > Thanks in advance for some replies!! (I hope) > >
Guest SnakeSteuben Posted August 6, 2007 Posted August 6, 2007 Re: Possible to: Tick or cross off dates as they go by? [image: http://www.dashlaw.com/emoticons/confused.gif] Say what? Cells? Days? Where? Huh? Html code? VB code? Excel? The windows calendar program? Am I being dense? Very possible, but I can honestly say I have no idea what you're on about. Men are like campsites. Women should leave them better than they found them. - My wife
Guest Ben Posted August 6, 2007 Posted August 6, 2007 Re: Possible to: Tick or cross off dates as they go by? Yep, sorry realised after I hit 'send'. "Gary S. Terhune" <none> wrote in message news:ew0bqO%231HHA.1100@TK2MSFTNGP06.phx.gbl... > What program are you talking about? This is a WINDOWS XP newsgroup. > > That said, and presuming you're talking about Excel, my guess is that it > can be done with a macro, but don't quote me on that. What you need is an > Excel newsgroup. > http://news://msnews.microsoft.com/microsoft.public.excel.programming > > -- > Gary S. Terhune > MS-MVP Shell/User > http://www.grystmill.com > > "Ben" <bswong@bigpond.net.au> wrote in message > news:O9xti.16311$4A1.11252@news-server.bigpond.net.au... >> For example (lets say all cells have black text): >> 06 Aug 2007 >> 07 Aug 2007 >> 08 Aug 2007 >> >> If today is 06 Aug 2007, nothing happens, all cells have black text. Go >> to sleep... now its 07 Aug 2007. >> >> Is there a way to cross/tick off the previous days automatically with a >> formula or conditional format? I want to make the text turn to red, eg. >> in our above example 06 Aug 2007 should now turn red because we are now >> 07 Aug 2007. >> >> Thanks in advance for some replies!! (I hope) >> >> > >
Guest Gary S. Terhune Posted August 6, 2007 Posted August 6, 2007 Re: Possible to: Tick or cross off dates as they go by? Hope you find what you're looking for. -- Gary S. Terhune MS-MVP Shell/User http://www.grystmill.com "Ben" <bswong@bigpond.net.au> wrote in message news:l0zti.16350$4A1.1065@news-server.bigpond.net.au... > Yep, sorry realised after I hit 'send'. > > "Gary S. Terhune" <none> wrote in message > news:ew0bqO%231HHA.1100@TK2MSFTNGP06.phx.gbl... >> What program are you talking about? This is a WINDOWS XP newsgroup. >> >> That said, and presuming you're talking about Excel, my guess is that it >> can be done with a macro, but don't quote me on that. What you need is an >> Excel newsgroup. >> http://news://msnews.microsoft.com/microsoft.public.excel.programming >> >> -- >> Gary S. Terhune >> MS-MVP Shell/User >> http://www.grystmill.com >> >> "Ben" <bswong@bigpond.net.au> wrote in message >> news:O9xti.16311$4A1.11252@news-server.bigpond.net.au... >>> For example (lets say all cells have black text): >>> 06 Aug 2007 >>> 07 Aug 2007 >>> 08 Aug 2007 >>> >>> If today is 06 Aug 2007, nothing happens, all cells have black text. Go >>> to sleep... now its 07 Aug 2007. >>> >>> Is there a way to cross/tick off the previous days automatically with a >>> formula or conditional format? I want to make the text turn to red, eg. >>> in our above example 06 Aug 2007 should now turn red because we are now >>> 07 Aug 2007. >>> >>> Thanks in advance for some replies!! (I hope) >>> >>> >> >> > >
Recommended Posts