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

    Is it possible to auto-format a cell's color based on when it was last edited?

    I'm working with a team that regularly modifies a single Excel worksheet. We would like to be able to easily determine what cells have recently been edited. Essentially, if a cell was edited/changed in the last week, it should be green. Once the edit is a week old, the edited cell goes back to...
  2. J

    Help with advanced VBA task please

    I'm comfortable with formulas, but very new to VBA and suddenly I have a task so advanced I don't even know where to start. I need a script that will go through all the rows in Column A (starting on row 2), create a range for matching cells (they'll be contiguous) and check if the cells of...
  3. J

    Need help creating formula array to look for text in cells

    I have two columns. The first has a string of text, (e.g., "010812_Sports&Outdoors_Exercise&Fitness_L2_Story1G1"). The second will either have "CMS" or "OC" in it. Thus far, I've been able to create a few formula arrays to show me the sum of all rows where there is both (for example) "sports" in...
Back
Top