Carrying formatting rules from left column

I posed this question before but my ask is clearer now.

I have a query with a transpose function which lays out data horizontally. Problem is, formatting rules do not carry over to side columns....therefore hoping for a VBA solution.

My query always returns at least 1 column (Column C "Incident #1) so all formatting rules will be in this first column. First column has both basic formatting and some conditional rules. The table can expand up to 200 columns or constrict to just 1. I would like apply the formatting as per Column C to all columns to the right of C.
Column D is not formatted.

Example of formatting is wrap around text, specific borders, date format, centered, highlight in bold red if specific words appear in cells.......

I would like to apply this code after a brand new data refresh.....

That worked beautifully!

Anyway to have a formula in C89 duplicate to columns to the right just as we did with formatting?

WideBoy.....is there a way to delete the formula in D89 and beyond when the table constricts?

Your VBA code works beautifully so after refresh, additional columns are added to the right of column C. Formula and formatting rules from C89 also carry over to the right. However if there are less columns than before after refresh, a reference error remains in row 89.

How to I prevent this?