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.