Preserving Conditional Formatting with an Advanced Filter

I have a workbook that tracks 72 entries (each in its own row) through a complicated submission and approval process. I've set up a macro to run an Advanced Filter that transfers entries to a separate worksheet (called Risks) based on a number of criteria. So for instance, if an entry has a submission due within one week, it shows up on my "Risks" worksheet. Or if our approval of their submission is due within 5 days, that will also put it onto the "Risks" tab. The macro and filter work well, and I have the macro set to run each time the file opens, and each time the data in the complete worksheet changes. The last thing I'd like to add is some conditional formatting that highlights which column met the filter criteria. My problem is, when I add this formatting to my original list, it disappears on the "Risks" worksheet when I run the macro.

I've tried recording a more in depth macro that re-applies the formatting to the filtered data, but since I don't know how many entries will be filtered each time, I have to apply the formatting down through row 73, and then I end up with highlighted blank columns below the end of the list. Not the end of the world, but doesn't look clean and I'd like to figure out how to only format the list itself. Let me know if I should repost in the "macro" section or if there's an easier way to preserve the formatting. Thanks for any suggestions!