Numbers for mac will not let me add more than 15 conditional highlighting rules

Good point, here is a screenshot of my Numbers window. The table on the left is where the raw data is input. The middle colored table is the calculations (just basically doing some averaging and offsets to center the range). The octagonal arrangement of colored cells on the right is the contour map (Z height errors on a circular surface). The cells with the values in them are the actual data points. The other cells data are interpolated and their value's text are made small (1pt) so as to be almost invisible. I have selected one cell with a value of -0.31. That is rule 16. The other white cells also have rule 16 values. Just to make sure that there was not something corrupted in my Mac or copy of Numbers, I emailed a copy of my spreadsheet to another computer. It generated the exact same result. That would indicate that it is in the spreadsheet data itself. If it is a bug in Numbers, then an alternative approach to get the proper result would be appreciated. Thanks.

Thanks for the response, but this is not a lack of a feature. I have typed in 20 rules before, so that is not a limitation. I have 18 rules right now, but rule 16 does not work. If I delete all rules and start over, then it won't take more than 15. I tried to export it to .xlsx and it does not support the kind of rules I have and only exports 10 rules. I tried exporting to Numbers (09) and it exports the bug with it or when reading it back in. This is so messed up. I am just trying to figure out how to save all this work and recover it now.

Interesting concept. I am trying to figure out how I can use it. I have 18 different colors, each corresponds to a different number range. So, total range is about -0.5 to +0.5 and a different color for each 0.05 increment. Each color is actually evenly spaced around the color wheel, but I don't think that helps the problem. I can obviously make a table of numbers and corresponding colors, but how can I make a rule that uses it?

I gave up and redesigned my contour map to only have 15 colors. Not quite as accurate (20 would be best), but at least Numbers lets me enter all 15 rules before calling it quits. Now I can get on with using the tool. Thanks to everyone who offered suggestions. It is heartening to have received responses of any kind in a short amount of time.

Perhaps there is a 15 rule limit. Perhaps I inadvertently got around the input checks the first time because I hit the add new rule button multiple times in a row before filling out the data in each one. It took them all, but perhaps its internal checks path did not account for inputing them that way. So, I had a data structure with 20 rules when it was only meant to have 15 max. Then every time I would delete a rule and try to add just one, it would not let me do it unless I was below 15 rules. That means the bug was not in executing the rules, but in not checking properly to limit the rules to 15. I looked for but did not find any reference to any limit on the number of rules allowed.

Thanks, I thought of that also. It is only rule 16 that does not execute. Rules 17 and 18 do execute. It does not matter what rule 16 is. I can rearrange the rules and it always ignores rule 16.