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

    Conditional Formatting - Dragging down

    Hi Vijay, I need the formula in the CF to change in row. Ie: Row 1 - =Sheet4!D1>1 Row 2 - =Sheet4!D2>1 Row 3 - =Sheet4!D3>1 The CF is looking at a Countif result relating to the main sheet. So if a record is added which matches a previous record the text turns red. Rgds...
  2. B

    Conditional Formatting - Dragging down

    Hi, I have been reading the other posts relating to this and been unable to find a solution. "Using a formula to determine which cell to format" I have this CF on a cell =Sheet4!D1>1 and want to be able to drag it down to row 2 onwards. With the formula auto changing to...
Back
Top