Hi all... hoping someone can help me!
I have a question about conditional formatting.
I have created a dashboard with a tab where I need to change the conditional formatting based on a drop down selection. This is because there are different average benchmarks for each selection. For example...
When I select option X from the drop down, I need the formatting to show green/red/yellow based on the average benchmarks for this option.
When I select option Y from the dropdown, I need it to do the same, however the average benchmarks for this option are different etc... there are 5 different options.
Dropdown is already set up - it's just the conditional formatting that I need to sort out now.
Any help much appreciated.
L
I have a question about conditional formatting.
I have created a dashboard with a tab where I need to change the conditional formatting based on a drop down selection. This is because there are different average benchmarks for each selection. For example...
When I select option X from the drop down, I need the formatting to show green/red/yellow based on the average benchmarks for this option.
When I select option Y from the dropdown, I need it to do the same, however the average benchmarks for this option are different etc... there are 5 different options.
Dropdown is already set up - it's just the conditional formatting that I need to sort out now.
Any help much appreciated.
L
