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

    Conditional formatting - error report

    Hello all, I have created a table with 31 columns. One of the cells has 2 Conditional formatting rules in it and one of the cells is a drop down list dependent on what was inputted in the previous cell. When I try to add a new row in the table and save - the error report appears saving there...
  2. C

    Error Report when adding rows into table

    All, I have created a table with 31 columns, only one row inputted. There are a number of lists, one cell of conditional formatting but that is about it. When a new row is added and I try save the Excel, the following warning comes up – 'One or more formulas in this workbook are longer...
  3. C

    Copying formulas/data validation/conditional formatting

    Dear all, I have table with a number of formulas/data validation techniques and conditional formatting rules in the first row. Row 3 has all the formulae I want in but as the table has a new row added to it for each new entry (new row becomes row 3), I would like the formulae and the...
  4. C

    Dependent drop-down lists

    Hi everyone, I am trying to sort out some pre-populated drop down menus. Depending on which one of 3 is selected in the first drop down, other options will be pre-populated in the next cell ie. Food Meat Vegetable Fish Meat Beef Carrot Cod Vegetable Chicken Peas Haddock Fish Pork...
  5. C

    Conditional formatting

    Hello, I would be grateful if somebody would be able to help me out with a conditional formatting issue I am having trouble with. I would like to have OPEN or CLOSED auto populated based on information in other cells. Essentially, there will be dates in A1 and B1. A1 will always populated...
  6. C

    Conditional formatting - Warning signs for approaching deadlines

    Hi everyone, to me this seems like a very difficult question but I am sure there must be the funtionality within Excel to be able to do this. Essentially, I would like to track items that have gone out to the client which have not yet been returned. The items must be returned within 2 months...
Back
Top