Add color and format data in table header and body only in excel export SSRS

Question

In my SSRS report body I have added a table with header. I need help in 2 tasks here please.

1. I need to add background color to the header of table only while exporting it to excel.(Not while viewing it on web/exporting to PDF)
2. If the table data repeats then I need to change rows to columns. Example:
   Name Age Details
   Test 24 Working
   Test 24 Married
   Test1 28 Working
   

I need above data to be the same while exporting it to pdf and viewing on web but it should change as below while exporting to excel.

Name Age Detail1 Details2
Test 24 Working Married
Test1 28 Working

Answer 1

Why not have two tables, one with what you want in excel and one with what you want otherwise. Then use Globals!RenderFormat to determine the hidden property of those two tables? Example here.