Creating links across worksheets based on text colour

[sil2011]

Hi,

I've had a look through some previous topics, but can't seem to find an exact answer to how to manage the following:

I am managing income data in one sheet to show 'paid' (black text) and 'unpaid' (red).

What I would like to be able to do is link all data in red to another sheet, to manage all 'unpaid'. Thus, when the text is changed in sheet 1 to black, it would then be removed from sheet 2.

Would this be possible, and if so would an IF statement be the best way to create a table in sheet 2?

Thanks

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.


Please be sure to familiarise yourself with the Board's Rules before posting further.