• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. A

    Text disappears from Graph (2007)

    Hi Cybermama Can you upload the file?
  2. A

    Print button

    Thanks Fred
  3. A

    Print button

    Hi all, What do I do to insert a pring button in my worksheet? Regards!
  4. A

    conditional formatting

    Hi SirJB7, I did the following and it worked well for me: =A2/A$1:U$1<0.5 Regards!
  5. A

    =IF returning True when it is False

    Hi Divelonger, In your Form sheet, change cell D3 which is called RowIndex to 24. this is the number that matches M24 and thus the result will be 75. Done
  6. A

    conditional formatting

    Hi SirJB7 The formula works very well for one column. My qestion is what if I had a number of columns each with a different heading. What formula may be used? Regards!
  7. A

    =IF returning True when it is False

    Hi Divelonger, There is a cell shift by +1 in your formulas in the data sheet. for example the formula in O1 contains [Data Master.xlsx]OFFICE'!M2="Y";"HAVE";"HAVE NOT") Notice the M2. i think it should be M1 and all the cells have the same error. Please amend it and see if it works.
  8. A

    conditional formatting

    Hi all, What formula to use for the following: I want to do CF for a number of columns that contain different values. The condition is if the cell contains 50% of the header value, then the cell is conditionally formatted red for example. Regards!
  9. A

    Drop down calender

    Hi, Try this link: http://www.fontstuff.com/vba/vbatut07.htm
  10. A

    =IF returning True when it is False

    check your system language. Perhaps your system understands > as <
  11. A

    Help with calendar

    Hi all, I have the following workbook. http://www.2shared.com/document/OAwwJwTO/2010-calendar_-_Calendar_highl.html It is a calendar. What I want to do is highlighting the current date in the Outline worksheet. Please give it a try.
  12. A

    Calendar highlighting

    Hi SirJB7, You see for example Cell B5 in the Outline worksheet contains the month of January and it is actuall a merged cell (B5 to H5) . I removed the merging of these cells so that I have individual cells B5 C5 D5 and so on. I did the same for the rest of the months . Please try this and...
  13. A

    Calendar highlighting

    Hi SirJB7, Thank you very much for the good try. Yes, it is weired action though it says it is OK when I do formula evaluation for AC11. I tried something else. I removed the cell merge for the month names. Please try it and see what happens. This issue turns to be interesting and...
  14. A

    Calendar highlighting

    Thanks a lot SirJB7, Can I do the same to the calendar in the outline worksheet? What formula would I use? NB the file worked well on excel 2010 not 2007. Regards
  15. A

    school timetable

    can we use excel to make a school timetable with classes subjects and teachers and seven period a day five days a week?
  16. A

    Calendar highlighting

    Thanx SirJB7 Here is my email ahmedmallook@hotmail.com Does it matter if I am using excel 2007? Do I have to use 2010?
  17. A

    Calendar highlighting

    Hi Sir No formulas yet
  18. A

    Calendar highlighting

    Gracias SirJB7, I downloaded the file. It does NOT contain any CF and the today's cel is not highlighted. You may have uploaded an unamended file. Would you pls send it again? Thanx
  19. A

    Calendar highlighting

    Hi SirJB7, As for the separators in the function, Excel 2007 that I use does not accept ( , ) as a separator and gives me an error message so that i had to change it to ( ; ). Yet, the program still does not accept the refernce to Outline! for CF Any solutions please? Thanx
  20. A

    Calendar highlighting

    Hi SirJB7, I liked your amendments. The holidays in my country are Fri. and Sat. so they are highlighted grey. Next, when I put the rule =DATE(Outline!$D$3;ROW()-3;C4)=TODAY() as a new rule in CF, I got a message saying I cannot use a reference to another worksheet for CF in this case...
  21. A

    Calendar highlighting

    Hi SirJB7 Thank you for your interest and reply. YES, the formula works well in the pictorial calendar, but this is not the calendar that I depend on in my work. I have uploaded my calendar for you to try to set the highlighting formula. I tried but failed...
  22. A

    Calendar highlighting

    @Luke M, Please check this page. Can the code be shortened? http://www.teachexcel.com/free-excel-macros/m-145,create-calendar-12-month-excel-macro-free.html
  23. A

    Calendar highlighting

    Thanks a lot luke
  24. A

    Calendar highlighting

    Thanks Luke, Actually I used the formula A2=today() , but as i said, all the calendar was formatted. The problem is that the cells contain just numbers and not dates. I mean they contain the numbers from 1 to 31 for the month of January and so on. They do not contain dates.
  25. A

    Calendar highlighting

    Hi all, In an excel calendar that depends on formulas to calculate dates, e.g. http://chandoo.org/wp/2012/01/02/picture-calendar-template/ I need to highlight the cell that shows the current date. I tried conditional formatting with a formula =TODAY() and chose to fill the cell red, the...
Back
Top