how to get colour one output file against multiple input file

Rajeev18

Hello

Please help me to find how to get 3 different output file with 3 different Input file in one excel workbook based on certain colour condition.

Example:- 
File- 1

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	Not sent	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	WIP	10/29/19	In Transmit	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

File 2: -

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	In Issue	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	Rejected	10/29/19	May get Rejected	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

File 3:- 

Product ID	Product Name	1st level Approval status	Date	2nd level Approval status	Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19
23456	N	In Transmit	10/19/19	Submitted	10/19/19
98766	Z	Accepted	12/13/19	In Issue	12/13/19
45678	A	Accepted	11/25/19	Accepted	11/25/19
32156	B	Rejected	12/13/19	Rejected	12/13/19
23457	C	Rejected	10/29/19	May get Rejected	10/29/19
45678	W	Submitted	12/11/19	In Transmit	12/11/19
12980	X	Accepted	12/11/19	Accepted	12/11/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19
234568	Q	In Issue	10/27/19	Submitted	10/27/19
98765	s	Accepted	12/13/19	In Transmit	12/13/19

One OUTPUT File Require with different tabs- 
Colour Condition as follow:-
In Transmit  -Yellow
Accepted - Green
Rejected, May get Rejected & In Issue -  Red

 

afv2688

Hello @Rajeev18 ,

For that you need to use the table tool from the reporting tools. There you need to set custom rules for each column.

Since there are 3 possibilities you need to add 3 rules for each one.

After that, add a formula giving it a name to each reporting.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

Edit: added a sample

report-creation.yxmd