need a measure or column

[bati1212]

rfp#	rfp name	phase	end date
1512	request badges	a-1	24/05/2023
1512	request badges	b-1	20/06/2023
1612	maintenance	b-2	22/01/2023
1612	maintenance	c-2	17/02/2023
1613	paper	d-2

a-1 finished and b-1 also has finished but still I can't follow my collegeue has opened c-1. therfore, need the current b-1 to be coloured with red colour for rfp # to give attention to the next phase to be opened and give maximum 5 days to open new phase or the measure will color rfp#. the same for c-2. However, 1613 still not completed yet, no need for any action to be taken, because there is another measure adjust this status.

serial#	phase
1	a-1
2	b-1
3	c-1
4	d-1
5	e-1
6	f-1
7	a-2
8	b-2
9	c-2
10	d-2
11	e-2
12	f-2
13	a-3
14	b-3
15	c-3
16	d-3
17	e-3
18	f-3
19	a-4
20	b-4
21	c-4
22	d-4
23	e-4
24	f-4
25	a-5
26	b-5
27	c-5
28	d-5
29	e-5
30	f-5
31	a-6
32	b-6
33	c-6
34	d-6
35	e-6
36	f-6
37	a-7
38	b-7
39	c-7
40	d-7
41	e-7
42	f-7

[bati1212]

I think either no answer to this situation or, no one want to help me.

Many thanks

[bati1212]

The second table contains only the sequence of phases (no more data just only to follow the sequence of phases). However, the first data is going to be detected. The link between the two data is the phase (a-1 followed by b-1, c-1 , d-1,....etc) is the next phase is established (if not, from the end date of the current phase count 5 days then give the rfp name or but highlight either text, background or new column "delayed")but measure need to check first which last phase for this rfp#, this phase comes to end (end date), no next phase in the sequence then highlight it when 5 days has finished.

[bati1212]

or

just need only rfp# not completed as :

rfp#	rfp name	phase	end date
1512	request badges	b-1	20/06/2023
1612	maintenance	c-2	17/02/2023

[lbendlin]

I do not understand the logic behind your ask. Is your sample data missing a date column?

[bati1212]

each rfp need to follow phases that shown (THE SECOND TABLE). So, when rfp stuck in a phase (as the example above) need to be known and colored. give 5 days after end day. Then, phase of rfp must be changed to next phase. If not, rfp# or rfp name must be colored with red either text or background.  

[bati1212]

rfp#	rfp name	phase	end date
1512	request badges	a-1	24/05/2023
1512	request badges	b-1	20/06/2023
1612	maintenance	b-2	22/01/2023
1612	maintenance	c-2	17/02/2023
1613	paper	d-2

need rfp# or rfp name to be colored no matter which one, it depends on the checking first the end date then checking the phase no. is it the last phase such as a-1 done b-1 done no c-1, so, need b-1 to be colored.

hope this explain is clear.

many thanks.

[lbendlin]

Please show the expected outcome based on the sample data you provided.