MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Create a Color Scale In Numbers Like I Can In Excel and Google Sheets?

I am trying to create a colour scale on Numbers like I can on excel or google sheets.

Example:
I have the percentiles 0% to 100% in a column. I want to create a scale where the colours go from different shades of pink (0%) to different shades of blue up to 100%.
—–
Ian

Comments: One Response to “How Do I Create a Color Scale In Numbers Like I Can In Excel and Google Sheets?”

    5 months ago

    You would do that with Conditional Highlighting. See https://macmost.com/conditional-highlighting-in-numbers.html

    But there isn’t any automatic way to use a scale. You’d need to set up 3 or 4 conditional highlights (or more) for value ranges. But once you set it up for a cell, you should be able copy and paste it using Format, Copy Style and Format, Paste Style.

    Definitely not as good as what you can do in Excel or Google Sheets though.

Leave a New Comment Related to "How Do I Create a Color Scale In Numbers Like I Can In Excel and Google Sheets?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)