I was trying to highlight the sub-category with high sales on a particular day. But my requirement is
1) I want to display the products in the highest sales sub-category in another worksheet
2) Suddenly the colors are not working. Strange
pls help me
Is there any chance that you can post a workbook with a screenshot of 1) describing what you want and 2) showing how the colors are not working? That will help somebody here try and tackle the issue you are hitting.
Retrieving data ...