How to have the tab color change when a particular cell has an entry. Or some other "Flag" that the cell has an entry, like the file name gets a "Warning" extension, or some other idea anyone may have. What I'd like exactly is if I select a line of text from a cell that is a pop up window I get a flag of some sort, other than the content of the cell changing. thx.
Numbers 3.2-OTHER
There is conditional highlighting in Numbers. You can set a table to have the cells that meet certain criteria change color, font style, or change the color of the Font. Is that what you are looking for?
This is how conditional highlighting works;
if you need any more help or this didn't solve you problem just ask.
Charles
There is conditional highlighting in Numbers. You can set a table to have the cells that meet certain criteria change color, font style, or change the color of the Font. Is that what you are looking for?
This is how conditional highlighting works;
if you need any more help or this didn't solve you problem just ask.
Charles
Thanks Charles. I know about Conditional Highlighting. What I'd like is more complex. Let me try to ask again another way.
I would like the tab of a multiple page file to change color (or some other "flag" other than a color change) if a particular cell has an entry. For example; If I enter "Not In" into a cell, the tab of that page turns from the default blue color to red. In addition, it would be great if the file name also had an extension added to it--for example; file name, Product_Counts.numbers would become Product_Counts-ERROR.numbers. "ERROR" would be added to the numbers file name when the cell has an entry. Thanks again for any help.
Hi pnm,
We don't have the control you are looking for of the sheet tabs. Our only control is over the name of the sheet itself and that we have to edit by hand.
It would be possible to write a script that, once run, would change the file name as you are suggesting. It would not be automatic, and someone with more experience than I would have to write it.
It would be possible to build a table that would list in what sheets::tables::cells you have chosen "Not In". You could locate it on its own sheet. It becomes a matter of how much you are willing to work at it.
quinn
thx quinn. at least i know to stop looking.
How to set up a "Flag" like a tab color change
