Help with excel formula relating to certain coloured text

spreadsheet formulas do not detect text color (nor most other formatting). you CAN use conditional formatting to format values based on built in or custom rules to apply a particular text color (or other formats like cell/background color).  And cell formulas will not move data but you can have a formulas that will 'add'/show data in a table/range.  A sample sheet and more specifics of what you are looking for would be helpful to make more specific suggestions.  But basically you can have a custom rule in conditional formatting to set the text color and then in those different columns for each week of the month you can have lookup formulas (e.g. XLOOKUP, FILTER) to pull and show the corresponding data.