What i Did: 1) Generated the Dates in Column B. 2) Applied the formula weeknum in Column C =WEEKNUM(B2,1) (To enable weeknum type of function: Tools > Add-Ins > analysis Toolpak )
3) in $D$2 cell, applied the weeknum for now() 4) Performed the condition format (Formula Is) as mentioned below: =$C3=$D$2 then clicked in Format > border > outine & Patterns > click on light yellow color as background color. Click 'ok' 5) Went to cel b2, click on format paint & applied to entire col B. Enjoy. On Fri, Jan 30, 2009 at 11:23 PM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > Use conditional format...... > > > > On Fri, Jan 30, 2009 at 4:07 PM, Ometoon <omet...@hotmail.com> wrote: > >> >> Hello, >> >> I am trying to highlight the present week with a border. The >> weeknumbers are shown in Cell A4:BA4. >> A function is used to give a notification FALSE or TRUE if the WEEKNUM >> is the same as the current weeknum (based on NOW() Function). >> >> I like to built a VBA statement which tells Excel to highlight the row >> of the current weeknumber with a coloured border. >> >> Can anyone help me with this? >> >> Thanks a lot! >> >> Regards >> >> Anton Mulder >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> > > > -- > Srinivasan Ethirajalu, > +91-9449279330 > -- Srinivasan Ethirajalu, +91-9449279330 --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
