ColorIndex and Conditional Formatting

  • Hi,


    Hoping for some enlightenment please.

    I converted a spreadsheet of data to a Table (TableMain).

    Depending on certain conditions, I have Conditional Formatting to format the relevant cells in Column N with a Red background (Interior Color).

    What I need to do is then copy the contents of the rows belonging to those particular cells in Column N to another spreadsheet.

    However, what worked before I converted to the Table now doesn't recognise the interior color now in order to detect them and copy etc.

    I need to detect the first Red cell in the column, copy the row's contents to the other spreadsheet and return to pick up the next Red cell's row to copy etc until finished.

    Any help appreciated.

  • Hi,


    Regarding how to detect your cell ...It is much easier to use the rule you have created for Conditional Formatting ...rather than the result.. i.e the red color ...


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim,


    Thanks for your reply. I'm not sure what you mean or how I use that here.

    The Table is a database of investigation files. When completed the cell in Column N is formatted Red indicating the information that now needs to be copied across into the other spreadsheet. Once that is completed, the Red background automatically disappears (by design).

    The rows won't be contiguous hence the need to go from the first Red cell through to the last used cell detecting all Red cells.

  • Hi,


    Could you post a sample file with just ten or so records ...


    Fake data is also fine ... since it is the sheet structure and your logic which will determine the solution ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim,


    Sorry for late reply. Been away. At the moment it seems to work. I'm not convinced I've sorted it. I'll box on for now but may need to revisit later. Thanks for your help so far.

  • No problem ...


    In case of need, do not hesitate to come back to Forum ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!