Thank you Thomas for your added input. We are concentrating more on the reports rather than the conditional formatting.

Thanks Robert! I agree OBIEE cannot be excel and should never be. I just created the prototype in excel of what I need in OBIEE. I have tried several ways but that didn't help. I am not putting in more efforts by coding the html tags to get the view. Appreciate your help.

Robert, I didn't get you correctly but what I am trying to achieve is formatting on either the table view or pivot table view. I need to see the report as below, doesn't matter in which view.