NUMBERS Is it possible to select all the cells that share the same background colour on an existing table?Numbers: is it possible to add multiple select elements?Count checked cells if cell on same row matches state in NumbersHow can I make two cells edit and display the same information in Numbers?Numbers: How Can I Make Rows and Columns Smaller than 9 Points?How to select or autofill all distinct elements from a column in Numbers?Is it possible to swap two cells content in numbers?Text substitution and change cell background colour. Numbers & AppleScriptIs there a way to reverse the order of rows in a chart?Numbers function that returns the location for the current cellUnmerge all cells in Numbers xls file
Latest web browser compatible with Windows 98
Why do Australian milk farmers need to protest supermarkets' milk price?
What has been your most complicated TikZ drawing?
How is the Swiss post e-voting system supposed to work, and how was it wrong?
Why doesn't the EU now just force the UK to choose between referendum and no-deal?
Best approach to update all entries in a list that is paginated?
How do anti-virus programs start at Windows boot?
validation vs test vs training accuracy, which one to compare for claiming overfit?
What exactly is the purpose of connection links straped between the rocket and the launch pad
Can someone explain this Mudra being done by Ramakrishna Paramhansa in Samadhi?
Deleting missing values from a dataset
How does Dispel Magic work against Stoneskin?
Are there situations where a child is permitted to refer to their parent by their first name?
Is King K. Rool's down throw to up-special a true combo?
Unreachable code, but reachable with exception
What to do when during a meeting client people start to fight (even physically) with each others?
What is the definition of "Natural Selection"?
Touchscreen-controlled dentist office snowman collector game
Provisioning profile doesn't include the application-identifier and keychain-access-groups entitlements
Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?
Running a subshell from the middle of the current command
When were linguistics departments first established
Coworker uses her breast-pump everywhere in the office
Do f-stop and exposure time perfectly cancel?
NUMBERS Is it possible to select all the cells that share the same background colour on an existing table?
Numbers: is it possible to add multiple select elements?Count checked cells if cell on same row matches state in NumbersHow can I make two cells edit and display the same information in Numbers?Numbers: How Can I Make Rows and Columns Smaller than 9 Points?How to select or autofill all distinct elements from a column in Numbers?Is it possible to swap two cells content in numbers?Text substitution and change cell background colour. Numbers & AppleScriptIs there a way to reverse the order of rows in a chart?Numbers function that returns the location for the current cellUnmerge all cells in Numbers xls file
I have a large(ish) table, which is 75 rows, and 120 columns. so, 9000 cells. They are all empty of data, but some of them have their background fill set to Colour A, and some have it set to Colour B.
I would like to be able to select all the cells that are currently showing as Colour A cells, and change their background fill in one go, rather than have to sit for hours on end, manually selecting the cells individually.
Is this possible, or do I have a long night ahead?
macos numbers
New contributor
add a comment |
I have a large(ish) table, which is 75 rows, and 120 columns. so, 9000 cells. They are all empty of data, but some of them have their background fill set to Colour A, and some have it set to Colour B.
I would like to be able to select all the cells that are currently showing as Colour A cells, and change their background fill in one go, rather than have to sit for hours on end, manually selecting the cells individually.
Is this possible, or do I have a long night ahead?
macos numbers
New contributor
add a comment |
I have a large(ish) table, which is 75 rows, and 120 columns. so, 9000 cells. They are all empty of data, but some of them have their background fill set to Colour A, and some have it set to Colour B.
I would like to be able to select all the cells that are currently showing as Colour A cells, and change their background fill in one go, rather than have to sit for hours on end, manually selecting the cells individually.
Is this possible, or do I have a long night ahead?
macos numbers
New contributor
I have a large(ish) table, which is 75 rows, and 120 columns. so, 9000 cells. They are all empty of data, but some of them have their background fill set to Colour A, and some have it set to Colour B.
I would like to be able to select all the cells that are currently showing as Colour A cells, and change their background fill in one go, rather than have to sit for hours on end, manually selecting the cells individually.
Is this possible, or do I have a long night ahead?
macos numbers
macos numbers
New contributor
New contributor
edited 2 days ago
Gaitch
New contributor
asked Mar 10 at 17:23
GaitchGaitch
112
112
New contributor
New contributor
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "118"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Gaitch is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fapple.stackexchange.com%2fquestions%2f353523%2fnumbers-is-it-possible-to-select-all-the-cells-that-share-the-same-background-co%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
add a comment |
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
add a comment |
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
You should be able to Select All the cells in the sheet, then in the Format Sidebar, click the Cell tab. Then in the Fill section of the sidebar, click the color well, then select a fill option. It will say Multiple Fills. You should be able to select No Fill and delete all background (fill) colors:
answered Mar 10 at 18:45
IconDaemonIconDaemon
12.3k62842
12.3k62842
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
add a comment |
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I’m sorry to have wasted your time: it seems someone else has edited my question post, and unwittingly totally changed the question I was asking to something else! I want to be able to select all the cells that are currently one background colour. For example: if I have a mixture of red cells and blue cells, I want to be able to select all the red cells, and NOT the blue cells.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
2 days ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
Do you happen to know if there’s a way to do it?
– Gaitch
15 hours ago
add a comment |
Gaitch is a new contributor. Be nice, and check out our Code of Conduct.
Gaitch is a new contributor. Be nice, and check out our Code of Conduct.
Gaitch is a new contributor. Be nice, and check out our Code of Conduct.
Gaitch is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Ask Different!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fapple.stackexchange.com%2fquestions%2f353523%2fnumbers-is-it-possible-to-select-all-the-cells-that-share-the-same-background-co%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown