Hi all,
I am attempting to base arrow colors off % thresholds.
I have attached a test file.
Is there a specific way I can use formulas to set certain % ranges for the conditional formatting to reference?
Thank you
Hi all,
I am attempting to base arrow colors off % thresholds.
I have attached a test file.
Is there a specific way I can use formulas to set certain % ranges for the conditional formatting to reference?
Thank you
If you change the Type to Number, and use the actual decimals in Value, the arrows should work properly.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
Thank you Melvosh. Yes that is exactly the issue. Sort of embaressing how I overlooked that hah. Cheers!
You're welcome, and don't be embarrassed. I have no idea why the Percentage type doesn't seem to work, even though it looks like it should. As far as I can tell, you had everything set up correctly, Excel just didn't like it for whatever reason.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks