Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Conditional Highlighting limitations

I need to have 16 different color fills in a cell.Numbers only allow 15 rules. Is there a way to enlarge the number of rules per cell? Or, is there a way to create a rule to change the fill of a cell to the color of a referenced cell rather than to the color chart.


As an example, I wanted to make a NCAA tournament chart with each team having a different color. As I fill in the chart, the fills of the advancing teams change. But it only allow me to do 15 teams and their are 16 teams in each division.

iMac, OS X Yosemite (10.10.1)

Posted on Mar 20, 2015 9:37 PM

Reply
19 replies

Apr 7, 2015 8:54 AM in response to gavenl337

Thanks for the tip. I have played around with your idea this morning and have come up with a few discoveries.


It appears that the trigger to limit conditional highlighting is the 15th entry. In my problem, I deleted number 15 and then did as you suggested and added 15 and 16 back with no entry in the data box. I could then go back like you did and enter the data for the last two rules. When I first tried it, it did not work, so I went back and deleted rules 15 and 16 and repeated the process by adding rules 15 16 and 17. Rule 15 was the original rule 15 which worked fine. Rule 16 was a dummy rule which said bold andy cell with Z in it. I put cell with z in it to test it and it did not work. so I removed my Z and used rule 16 as a dummy. Then I made a rule 17 which was actually the rule I wanted. That worked fine.


I found that if you were adding a lot of rules and you had to leave the spreadsheet, you lose any rules that does not have data in it. A solution to this would be if you were going to have a huge number of rules, make the rules you need leaving the data blank and then go back and set each rule to text is z or any other character you want and do that fall all the rules. Then you can close the spreadsheet and come back later and all the rules that you created with the filler z can be edited to the actual values. If you press done before you have a value in the text box, it will delete that rule.


I am going to try 32 rules and see what happens.

Apr 7, 2015 12:29 PM in response to Yellowbox

Hi yellowbox


Just as an update to the above, I entered 70 rules (so that I would have 6 spare). Then I filled them in and the only rule that did not work was 16. All the others did fine and I checked all the cells and they read the rules.


I was able to have all of my brackets colored through the championships by just having one set of 64 (actually 65) rules.


Thanks to both of you for the solution. I guess the bottom line is you have unlimited rules as long as you get by the dreaded 16.

Apr 7, 2015 5:50 PM in response to Yellowbox

Hi Ian


I am moving on to my tennis spreadsheet. This is quite a bit more of a chore than the piddling NCAA bb tournament. Although I did watch the second half of the finals yesterday.


This sheet has 128 contestants not counting the qualifying matches. The qualifiers are not really important, but I gave them a table of their own. I am assigning colors now. Being lazy I am using 32 of the standard crayola colors for the fill 4 times each. If my hypothesis was right I will only need 129 rules, but I will probably make 140 just to be safe.. I will let you know how it works out.

Conditional Highlighting limitations

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.