Sorting and conditional formatting

Hello,
I am trying to do sorting and conditional formatting of two tables. They are presented in the atached example in sheet "Results". In short, with the help of several comboboxes, data from sheet "Source data" is filtered and copied in sheet "Results". So this is where we start from. Already copied ranges in "Results" should be sorted and formatted conditionally. Keep in mind that the number of rows and the data will vary according to the change in comboboxes.
Goals for the sorting:
1. The left table should be sorted by its last column (Growth N), the right table should be sorted by its last column (Delta N). Sort type - descending.

Goals for the conditional formatting:
1. Conditional formatting should be applied to the already sorted tables.
2. The rows of left and right table should be colored according to the following rules.
3. Formatting should be applied independently to the left and right table.
4. Top 25% of the rows should be colored in green (except headings). Last 25% of the rows should be colored in red. The middle 50% of the rows should be colored in orange.
5. If the number of the rows in the top 25% rows is not integer, then apply round function . If the result is round up, then increase the number of the rows in the top and last 25% and decrease them in the 50%. (For exmple, with 7 rows, top 25% - 2 rows, middle 50% - 3 rows, last 25% - 2 rows. If the result is round down, then increase the rows in the middle 50%. (For example, with 5 rows, top 25% - 1 row, middle 50% - 3 rows, last 25% - 1 row). But with 6 rows I suppose it is fair to add more rows to the middle 50%, despite that the round is up.
6. If we have only one row to format, let's make it green. If we have two rows, the first is green, the second is red. If we have three rows, then the first is green, the second is orange and the third is red.

If you have any suggestions, you are welcomed.

Thank you