Copy rows based on color (conditional formatting)

[sharky12345]

I have a sheet called 'Data' which has 20 columns and 10,000 rows.

Each row is formatted, (conditionally), so that they change colour depending on the value of the entry in column B.

For example, if the entry in column B appears only once then the row colour remains white. If it appears twice then the color is yellow and 3 times is red.

Now here's the bit I am stuck on - I need to do 3 things;

1) I need code to identify the rows which are white, then select ONLY the ones which have the cell in column 19 empty and copy them to a 2nd sheet called 'Letter 1'

2) Code to identify the rows which are yellow, then select ONLY the ones which have the cell in column 19 empty and copy them to a 2nd sheet called 'Letter 2'

3) If it is possible, I need code to identify the rows which are red, then select ONLY the ones which have the cell in column 19 empty and copy a screenshot of them to the body of an email message, can this be done?

This is a big ask I know, but I'm sure someone will come up with all or part of the answer!

Thanks in advance!