I was just going through some handy shortcuts in Excel and thought I’d toss this on my website for all of you. You can select multiple sheets/tabs at once in a workbook and apply a formula/formatting to a cell and have it be applied to all sheets. You can also check out the formula I used in this example. I used the index formula nested with the max formula to identify the highest sales value by product category. This formula translates over automatically to each country tab. Have a look for yourself.
If you have any questions feel free to drop a line in the comments.