You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I was wondering if it is possible to have a variable colour fill that is linked to a percentage.
By that I mean when the percentage is zero that there is no colour fill, at 50% then the cell is half filled with colour, and at 100% then it is completely colour filled.
iPad Pro (6th generation)
Not directly, the color is fixed for each conditional highlighting rule and is not controllable by external forces (except maybe by AppleScript though, I'm not sure, but you'd have to run the script each time you change a value.)
What you can do to cheat that is define a bunch of rules that use the same color but with decreasing opacity as the value goes down. Here I only have three rules, you can make as many as you want levels of shading.
Not directly, the color is fixed for each conditional highlighting rule and is not controllable by external forces (except maybe by AppleScript though, I'm not sure, but you'd have to run the script each time you change a value.)
What you can do to cheat that is define a bunch of rules that use the same color but with decreasing opacity as the value goes down. Here I only have three rules, you can make as many as you want levels of shading.
Hi scatrdj,
I admire the reply by Recycleur using opacity. Thank you Recycleur!
Another way to cheat is to use extra columns in the table to mimic a graph.
Formula in C3: IF($B3≥C$1,"Y","")
Fill down to the bottom of the table and fill right to column M.
Now select cells C3 to M11 and apply Conditional Highlighting to both Text and Colour Fill (green):
Now tidy up.
Hide Row 1.
Have a play with Format > Cell > Border > Border Styles
Regards,
Ian.
Color fill linked to a percentage of the cell size
