Filter report table by cell color

[Travis_Ratliff]

I have a sample workflow that appends a transactions file with a contracts file and then highlights the transaction cells green or red based on if they match the contents of the contracts file. What I would like to do is now separate the rows that are all green meaning all of the transactions match all of the contracts from the ones with red meaning they are not a 100% match. 

Any help would be greatly appreciated.

[CarliE]

Hi @Travis_Ratliff 

When you say separate, do you want them outputted to a separate table?

[Felipe_Ribeir0 · Accepted solution]

Hi @Travis_Ratliff 

If i understood weel, it is something like this right:

[Travis_Ratliff]

Yes, however, you are separating the tables before making them I was wondering if there is a way to separate them after making the table. 

[Travis_Ratliff]

Yes, @CarliE I would like them to be two separate tables so that when I use my render tool I can put them on two different worksheets.

[Felipe_Ribeir0]

As far as i now, after you turn the dataset into a report table, it is impossible to separate them.

But why you dont just separate them before and assign each one to a different sheet?

[Travis_Ratliff]

@Felipe_Ribeir0 I had not even considered doing that until you mentioned it so I thank you because you saved me a lot of time and steps.