[Solved]Write Sub Vba Highlights Yellow Maxed Sales Month Product Given Year Question Given 10 Pro Q37204734

Write a sub in VBA that

highlights, in yellow, the maxed sales month foreach product in a given year. In thisquestion we are given 10 products in a table much like the onebelow.   

Example: $700 should be highlighted in yellow for Product 1(P1)

ProductsJanFedMarAprilMayJuneJulyAugSeptOctNovDecP1$100$134$100$150$400$500$700$300$300$350$100$250p2p3p4p5p6p7p8p9p10

Expert Answer

---

Answer to Write a sub in VBA that highlights, in yellow, the maxed sales month for each product in a given year. In this question … . . .