Greetings.
I have a dashboard that is looking at a number of columns, but two in particular are Variance Dollars and Variance Percent. I am trying to find a way that a user can enter a value and change the highlight. For example, the user may want to highlight any cell red if the Variance Percent is greater than 150%. Next they may want to highlight red if the Variance Percent is greater than 125%. Similar with the Variance Dollars. First, shade for anything over $1,000. Next may want to see anything over $1,500.
Can this be done?
Thank you in advance.