Conditional Highlighting limitations

Unfortunately, that is what I have done. I can only do this 15 times with 15 different colors. Then it will not let me do it the 16th time. I either need to be able to make 16 rules for one cell or I need to be able to say change the fill color to the same color as cell A1 for example.

I am using the rule for text is a cell referrence.

Thank you for the comeback though although it does not solve my problem.

Thanks for the effort.

Since my sheet looks like a basketball bracket (It is), it would be possible to get by with 15 rules if you could change the color by referencing another cell to get it's color.

I am afraid that the limitation of 15 rules is driven by Apple's desire to make Numbers for the Mac compatible with Numbers for the Ipad.

Oh well, I guess you cannot have everything. I really like the conditional highlighting. I will drop Apple a line.

Thanks again.

Hi Ian

You seem pretty savvy about Numbers, so I will ask you one other quick question. I think Excel or the old Lotus 123 used to have a fucion that would allow you to either use a value in a cell as the name on the tab for that sheet or it would allow you, using a function, to put the page name in a cell on the sheet.

For example. I have a spreadsheet with each page being a separate identical spreadsheet with different data for different weeks. As it is now, when I copy the master sheet to make a new spreadsheet for another week, it would be nice if when I change the name of the new page to let me use the date and have it come up in the bdginning cell of the spreadsheet,

I am afraid that this wish may also be too much for Numbers. I would much prefer ,ore rules above.

Thanks again for your comments above. You did get my problem correct. I think I would also ask Apple to put the custom style at the top since everything I do is usually a custom color.

Frank

Hi quinn

In this case I can live with 16 colors. I have another spreadsheet that I use that has a requirement for 64 colors. Since I have been working most recently with the smaller spreadsheet I use it as an example.

I would be dead in the water if the spreadsheet had 20 colors.

Thanks for the comment

Frank

Thank you Yellowbox for your sample.

It has taken a few days but I was able to fit it in my spreadsheet. I have done a sample of approximately 1/4 of the spreadsheet using your solution. If you are interested, you are welcome to see what it does.

The funny thing of all this is this year it did not matter since none of the number 16 teems won their first game. haha.

Let me know if you are curious and I will put it on Dropbox (I have not used dropbox before, but I did open an account when I got your file).

Thanks for your help Way back in the old days I was on the Quattro Pro beta team and we used to send spreadsheet solutions back and forth. In those days there was no internet, but if you were working with Borland, they gave you access to a free bulletin board on Compuserve where you could trade files and comments. Those were fun days.

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.