Update Row Count and Highlight Cells with Color

[EmilAlteryx01]

1 - How can I include the count in Row 9, where the '-' represents the count? Please refer to the attached Excel file, which shows the outcome displaying a numerical count.

2. Highlight the cells in Row 9 that are not 0 in yellow?

[alexnajm]

1) Calculate the counts and output directly to that range

2) Conditional formatting in Alteryx is only done with rules in the Table tool - instead can you output the data to Alteryx and "preserve formatting" so the conditional formatting happens in Excel instead?