Excel 2007. In a row I have a calendar from I6 (1-Jan-09) to NJ6 (1-Jan-10). I need a formula or a conditional formating to highlight the dates are on Sundays on a calendar. for example 4-Jan-09
OS: Windows Vista; Browser: Firefox
Hi,Take a look at this link .See if it solves your problem.http://www.bettersolutions.com/excel/EPX299/MN721914332.htm
ption 1: I want to make a program in excel for a project. What I do not manage to do is: I want to edit my formula so all the dates from the calendar row wich comes to be on Sundays the cell to be a diffrent colour or the font to be red for example.This is my formula: =IF(ISERROR(A3+1),"",IF((A3+1)<=$G$2,(A3+1),"")), so all the dates changes as I change the date in "Project Finish date"Example 1 - is what is now
Though i am a programming expert i dont have much idea on excel.So i will forward this question to programming category where there are a lot of excel experts.
Hi,I find that you are kept waiting.At present there are three are only 3 programming experts including me online.If you can check after 1 or 2 hour there should be someone to help you.
Tony,Is this what you're looking for?
Almost. That one I managed to do it easy with conditional formating. I want also the above cell with the date (ex. 04-Jan-09) to get changed automaticly with the same colourSee Example below:
CustomerSorry for the delay... I got tied up for a bit..For the date row, you will need to create a new conditional format like this:
10+ years experience programming in a variety of languages
Perfect. Can I get more help for this document?Explanation of the document: Is is a Excel document to control the projects (construction industry). I do not want to use MC Project because my colegs do not know how to use it. That's why I am doing it in Excel. What I want more is I want to add about 200 tasks in rows. Somewhere in the top of the document in a cell I want to make a formula/condition/filter/whatever is possible to be able to select only 25/50/100/150/200 tasks (rows). So I only see the rows I need. I think a formula which can hide rowsSee example of my document
Altough this is a completely different and new question, I can still help you out...This one is tricker... It involves writing a macro and running it every time.If you want, you can upload your file to http://wikisend.com or www.rapidshare.com and copy/paste the link that you're given into a Reply here.I can write the macro for you...Thanks,Mike B.
Thaks a lot. I need 30 minutes to build up the 200 tasks. I am so glad I found a way to get helped (even if I pay for it). I will foward your website to all managers.
No problem... Take your time.Thanks,Mike B.
Toni,I'm going to have to leave in a bit, and won't have time to work on this until tomorrow. If you want, you can send me what you have now, and I'll put my macros in.Otherwise, we'll have to finish this up tomorrow.Let me know.Thanks,Mike B.
Thanks again, I think from now on I am not going to be stressed regarding applications in excel. I will send you tomorow all the information what I use the excel for (about 30% every working day) and I want a quatation for a monthly fee for about a year. I love excel But I have a lot to learn.Regarding my document (project planning template), I will appreciate a lot if you realy think that you can give a better ideea on how to change it and make it batter. I want to make it very similar with MC Project.Good Buy,Customerbr />http://wikisend.com/download/156468/Project Planning Template byCustomerxlsx
Toni,I'm going to have to spend a bit more time on this, and I can't do it right now. I don't want to rush and mess it up.Let me get back to you tomorrow with the completed worksheet.Thanks,Mike B.PS: Thank you for the payment and the bonus... It is greatly appreciated.
No need to hurry. Take your time.Good Night,Customer
Toni,I would love to give you a monthly quote... however, there is no option on JustAnswer to facilitate this. Also, it is against JustAnswer policy to exchange contact information.I have added the scripts to your spreadsheet. The spreadsheet was converted to a macro enabled spreadsheet.To get my scripts to work properly I had to remove the blank rows between tasks. Although the blank rows make your spreadsheet look really nice, they are a menace to scripts and some other advanced functions in Excel. Blank rows (and cells) act as section breaks in Excel, indicating that a group of entries are separated. Therefore, if you want to programmatically find the end of a group (like figure out the number of tasks), it makes it very hard to do, having blanks between data rows. I hope that you're ok with that.Let me know if you have any other questions. If you have new questions, and you wish to get my support, you can start a new question and make sure the subject contains: "To Mike B."Your file is located here: http://rapidshare.com/files/217312787/Project_Planning__Template_by_Toni_Timis.xlsm.htmlPlease let me know as soon as you have received the file.Thanks,Mike B.Mike B39907.5115375347
Hello,I have an excel 2007 table. In the Fig.1 you can see the filter icon to every colomn. I ussualy use the filter only in the first colomn (Task 1). option 1) - How can I hide,remove the filter icon from the rest of the colomns? see Fig.2.option 2) - How can I apply the filter to the table only to the first colomn (Task 1)? see Fig.2Note: I must use a table so the table do the calculation (total Row) for each colomn, when I filter from the first colomn (pretent I do not want to see the blank rows) the "Total Row" change also the calculations (SUM) to the next colomns.I already tried only the first colomn as a table, I can apply the filter only to that colomn but when I use the filter (pretent I do not want to see the blank rows) the "Total Row" calculates only for the first colomn where the table is. For the rest of the colomns I tried to do the(SUM) manually but, when I use the filter from the firts colomn (pretent I do not want to see the blank rows), the bottom total row will not change the calculatios once a row is removed (I know, because the rest of the colomns are not part of the table.Fig. 1Fig.2p
is anybody going to help me with the question above?