Dashboard Rule - Conditional Color Based On Varilable Parameter

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.

It can, but you would have to custom code it so that you can get the value from a text box or something. I don’t think you can do it with the normal row rules that you can use in a dashboard.