Set color to excel cell dynamically (black , text1 , lighter 25%)

Hi everyone,

my requirement is i need to apply (black , text1 , lighter 25%) and bold to the headers in the excel
and headers are dynamically placed in the excel

No. of rows are dynamically , column headers can be placed any where and years of service is also dynamic

currently i am using

but not able to apply (black , text1 , lighter 25%) parameters to them
Any suggestion @ppr @Yoichi @Palaniyappan @supermanPunch

Thanks in advance