Conditional highlighting with a color scale

#1 can be done, with additional cells that are calculated based on the min / max value

As long as you have a handful of different groups.

#2 is currently not possible, "continuous range of color intensities" is not available.

You would have to create steps of color intensities that will work for you.

It would be helpful if you could post an example of what you want to achieve, that will help to give a good answer.

What is the reason why you want to use Apple Numbers and not Google Sheets?

Pick the one that works best for you, each Software has good and bad areas. You must make a decision on what works best for you.

I personally run Microsoft Excel and Apple Numbers, based on the task that I have to perform.

Ralf

Hi Rich,

Hi Léo,

currently that is not possible with Apple Numbers.

I would recommend that you send a Feedback / Request to Apple, only they can implement something like this.

Product Feedback - Apple

Please describe exactly what you want and why this would be a benefit for all Apple Numbers User.

Best case they will see the benefit of this concept and implement it in one of the next versions.

Ralf

Hi Rich and Ralf, jumping in here because I'm looking to do the exact same thing!

My use case is that I am plotting speed on the x-axis, heart rate on the y-axis and I'd like to have a continuous range of colour for the points based on the date of the run. This would enable me to track my heart fitness (increasing speed but decreasing heart rate) over time. Does that make sense? I've attached an example that's missing the colour based on the date.

Cheers,

Léo