I’m wondering if Apple Numbers has a conditional highlighting setting that shades the cell based on its value within a range of numbers.
What I have is a row of correlation coefficients, which range from -1 to 1. I’d like -1 to be red, then get less red as it approaches 0 which should be white, then get more green on the way to +1.
Here is the corresponding feature in Google Sheets for reference:
Thanks for any help!
Format(the paint brush icon)->Cell->Add Conditional Highlighting
I don’t think so. That’s all I see ↓
After you choose a rule you’ll see the rest. The iPadOS implementation is clearer IMHO.
I went through the next steps and even tried on ipad. I still cannot figure out how to do a color range of conditional formatting. Any thoughts?
It is definitely not as easy nor intuitive as Google Sheets or Excel. However here is an example of how it can be done manually
Thanks @Nick_Fulgham, that’s exactly what I had in mind.
That’s really disappointing that they don’t have such a simple and useful feature. I guess I’ll do that.