show a due date using data from multiple columns

I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns.

I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2.

Table 1.  populated in cells G9:N12

ID        Description       Due Date 1    Due Date 2   Due Date 3    Due Date 4    Due Date 5    Out of Service?
1234    Instrument 1    11/17/2025    N/A              1/31/2027      3/11/2026     11/17/2027    FALSE
1235    Instrument 2    1/14/2026      2/17/2026    3/31/2027      1/23/2026     12/29/2027    TRUE

Table 2.  Conditional formatting rules applied to cells I9:M12

This Week = White font color, Red fill
This Month = Red font color, Light Red fill
Next Month = Dark Yellow font color, yellow fill

Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week:

ID        Description       Due Date 1
1234    Instrument 1    11/17/2025