NUMBERS Is it possible to select all the cells that share the same background colour on an existing table?
Clash Royale CLAN TAG#URR8PPP
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
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
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
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
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
edited Mar 11 at 10:51
Gaitch
asked Mar 10 at 17:23
GaitchGaitch
112
112
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
add a comment |
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
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.4k62843
12.4k62843
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
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
Mar 11 at 10:43
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
Mar 11 at 10:43
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
I have now edited the original to do that it asks the question I need to know the answer to.
– Gaitch
Mar 11 at 10:52
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Not a waste of time at all. Happy to help, although in the end it was futile. :-)
– IconDaemon
Mar 11 at 16:25
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
Do you happen to know if there’s a way to do it?
– Gaitch
Mar 13 at 10:07
add a comment |