Hi, I have a table with several metrics in rows, and monthly data going across the table horizontally with a totals/averages column at the end.

Because the monthly data will eventually stretch over several years (some of which will be hidden when not in use) I wish to include a drop down selection list on the totals/averages column to allow the user to select which year of data they wish to calculate totals of.

Upon selection of the year, I would like each row of totals to include the same formulae, but for a different range of data.

Furthermore, I was wondering if it would be possible to include a calculation within a conditional format? I want a value to be highlighted if the % based on two other cells is less than a certain amount.

I've tried googling for a solution to these queries with little success so any advice would be appreciated.

Regards,
Tom