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

19 replies

Yellowbox

Level 7

21,945 points

Mar 21, 2015 12:44 AM in response to feaco1

Hi feaco,

Sorry, I missed the point. It is not the number of colours available, it is the limit of 15 rules 😊.

Regards,

Ian.

Yellowbox

Level 7

21,945 points

Mar 24, 2015 10:00 PM in response to feaco1

Hi Frank,

Glad it worked out. Yes please put a copy on Dropbox, I would like a look.

Regards,

Ian.

feaco1 Author

Level 1

4 points

Mar 24, 2015 10:43 PM in response to Yellowbox

Here is the file. I think we have been talking along the same lines.

https://www.dropbox.com/s/am7obagzvqytm9m/NCAA%20Tournament%20color%20test.numbe rs?dl=0

Thanks again.

Yellowbox

Level 7

21,945 points

Apr 7, 2015 5:03 PM in response to gavenl337

Hi Gaven and Frank,

So it's Rule 16 that is the culprit. Good idea to make that a dummy rule.

When a document works as desired, Save as Template for future use 😉.

Regards,

Ian.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Conditional Highlighting limitations