Filter data by Columns (a,b,c etc) and mark the top 3 items for each filter.

Hi,
I need some help please to be able to quickly sort a table on "Date / Time" and (firstly) another column (F1). Then I need to have the T3Fn columns of F1 (for each unique Date / Time) filled with the percentage values for the Date/Time/F1 data set.
(See attached file).
It would be extremely useful if the unique "Date/Time/F1" and the new column "Date/Time/T3F1"set of data could be conditionally coloured with Red to Green scale.

After the Date/Time/F1 sort, I then need to sort table on Date/Time/F2.

Again, it would be extremely useful if the data could be conditionally coloured with Red to Green scale.

I need to repeat this for F3 and F4 also.

This takes too long to do manually and I've looked at trying Index/Match in formulas but can't get my head around it.

I tried recording macros but can't seem to get anything working since the ranges are dynamic owing to the filters.

I'm sure it just needs a VBA that loops on each filter but my VBA skills are minimal.

Any help would be gratefully received.