Symbols in cell's Numbers, like to change stars in star ratings into arrows

Question

Level 1

13 points

Symbols in cell's Numbers, like to change stars in star ratings into arrows

In Excel it is possible to link a symbol to a value in a cell. How is that in Numbers ? If I have values of 1 up to 5 (for example; priority) I know I could use the drop down format or the star ratings. But I would like to see a down facing arrow for less priority or a horizontal arrow for normal priority and upward facing arrow for most urgent priority. If I would use the dropdown menu can I conditional format a cell with symbols ? as well as with colors ?

Or could I change the "Star" symbol in star ratings ?

Below is an example made up with Excel.

Anyone any idea if it is even possible in Numbers ?

MacBook Pro (2017 – 2020)

Posted on May 6, 2024 3:06 AM

Reply

Answer 1

SGIII

Level 8

37,920 points

May 6, 2024 5:48 AM in response to Mrfra62

You can do something like this:

=SWITCH(A2,1,"⬇️",2,"↘️",3,"➡️",4,"↗️",5,"⬆️")

I got these symbols from Emoji & Symbols included on the Mac. Couldn't find colors as in your example.

If your Priority cells are formatted as Text instead of Number then you need to use something like this:

=SWITCH(A2,"1","⬇️","2","↘️","3","➡️","4","↗️","5","⬆️")

More on SWITCH here:

SWITCH - Apple Support

SG

Reply

Answer 2

Badunit

Level 7

31,321 points

May 6, 2024 6:50 AM in response to Mrfra62

Building on SGIII's solution, you can use conditional highlighting to make the cell color red for down arrow and green for up arrow. Set the background to yellow for everything else.

Reply

Answer 3

Mrfra62 Author

Level 1

13 points

May 6, 2024 8:27 AM in response to Badunit

Thanks guys. It works. Thanks

Reply

Symbols in cell's Numbers, like to change stars in star ratings into arrows

Similar questions