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,

Done, this time it takes only data from the day before.

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

Regards

[Rajeev18]

@afv2688 .  Unfortunately this is not giving the required result, could you please re look into this and share the rectified details.

one simple example-  - Considering today's date -7 March 2020, then i would require data for date 6th march 2020.

Input file:- 
 

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

Output file data require like this:- 

Product ID	Product Name	1st level Approval status	1st level Date	2nd level Approval status	2nd level Date	2nd level Approval status	3rd level Date
12345	M	In Transmit	12/13/19	Submitted	12/13/19	Rejected	03/06/20
23456	N	In Issue	10/19/19	Submitted	10/19/19	Submitted	03/06/20
98766	Z	Accepted	12/13/19	In Issue	03/06/20	In Issue	12/13/19
32156	B	Accepted	12/13/19	Rejected	12/13/19	Accepted	03/06/20
23457	C	Rejected	03/06/20	May get Rejected	03/06/20	May get Rejected	12/12/19
45987	Y	Rejected	12/01/19	Submitted	12/01/19	Submitted	03/06/20
345678	Z	May get Rejected	12/11/19	Accepted	12/11/19	Accepted	03/06/20
234568	Q	In Issue	03/06/20	Submitted	10/27/19	Submitted	10/27/19