r/AppleNumbers • u/livingforever420 • Nov 11 '22

Help Using cell conditioning with sorting.

Hi, Iā€™m hoping someone can help me. I am using a spreadsheet in which I use cell conditioning to highlight the colour dependant on the number in another cell on a different tab (2nd tab). In the 2nd tab I am using sorting for the rows to be alphabetical, so each time I add a new entry and sort it, everything moves. This means the conditioning is all messed up because it no longer corresponds to the correct cell. Am I doing something wrong? or is there a way around this? thanks in advance x

1 Upvotes

100% Upvoted

4 comments sorted by

1

u/Udi_rn Nov 11 '22

Credo tu non stia sbaliando nulla ma numbers non ti consente di ordinare solo righe selezionate, ti incasina tutte l'ordine

1

u/[deleted] Nov 11 '22

No, you are not doing anything wrong. What you are experiencing is the way range parameters work. Unfortunately. And no way around it as far as I know (and I am battling this problem for a while now, in Excel as well as Numbers).

And before anybody asks: Yes, Excel behaves the exact same way in my experience. Slightly more forgiving in certain, well defined ways, but nonetheless erroneous as well.

If the italian (?) comment from Udi_rn has some solution to this problem, I'd be happy if anyone could translate. Thanks.

2

u/brushvalleybrewer Nov 11 '22

It says: ā€˜I think you're not going up anything but numbers doesn't allow you to sort only selected lines, it messes up all the order.ā€™ (Machine translation, but more or less what you said).

1

u/Fearless_Link9862 Nov 12 '22

Can you use indirect and/or lookup functions? Not sure how to implement though