• 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. K

    Conditional formatting in 2010

    Never thought of that one Hui, but thanks, it is working fine now! Your's would havve been a quicker option though!
  2. K

    Hello .. Introduce yourself

    Hi all,Kassie here. Old guy who loves Excel, that is prior to 2010! Soon as I get to know the latest edition better, I'm sure I will also love this one! Haven't had any formal training in Excel, or any other subjects computer related, but am as far as I am concerned very computer literate...
  3. K

    Conditional formatting in 2010

    As I said, I am trying to highlight Saturdays and Sundays. So, by using this formula, for the first of the month, I take the starting date, which is in $E$1. I add to this either a 0($A$2) or else the previous day's date, so that 7 January is made up of $E$1, which is a 1, plus the cell above...
  4. K

    Conditional formatting in 2010

    =WEEKDAY($E$1+$A2,1)=1. At first, I again got the error message. I again cleared all formatting rules, saved the file, closed and re-opened it, and then it worked! Thanks for your interest in any case Hui!
  5. K

    Conditional formatting in 2010

    Awful sorry Hui, here is the correct formula, and when entered correctly, it still does not want to accept it. =WEEKDAY($E$1+$A2,1)=1
  6. K

    Conditional formatting in 2010

    Told you I must be stupid! Tell me how you do it? I have tried several times, and every time I get the same error message. I have now deleted these rules, highlighted range A3:B33, and entered the same formulae again. This time around, it accepted the rule, but .... Only Cells A3:B3...
  7. K

    Conditional formatting in 2010

    In XP, I set up a page-a-month calender in 2 columnsand 29-31 rows each. I enter a starting date in Column E1. and fill col A from 1-however many days in the particular month, from A3. I then block eg A3:B33, and entered the following conditional formats: =WEEKDAY($E$1,1)+$A2=1 and also...
Back
Top