macosnumbers
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?
To save on the cramming part of the Chart you could try using an interactive Chart with a scroll bar.
1, Start a new sheet and fill it with your data:
2, Go to the Chart menu and select Interactive Chart & the style you want.
I have chosen the simplest. Others you may have to play more with.
3, Click the Chart and then it's Add Chart Data button.
4, select either rows by clicking on each day of week row.
4.1 Or Columns by clicking on the WEEK columns
5, Click the DONE button at the bottom of the page when you have completed your selection.
If you need to remove/add a column or row from the Chart data. Then Click the Chart. And then the Edit Chart Data button.
Adding is the same as you did before.
Removing is clicking on the row or column and hitting the delete/backspace key. this does not remove the eta from the sheet only from the chart.
The chart I chose has a scroll bar which you can scroll through.
You can change the text size by using the format palettes.
And you can add labels to the Chart columns
by using
If I figure how to make it pick up the sheet info by it's self I will update.
Thanks to your sample file, I think I was able to do what you wished.
Using an additional column to bring in the numbers corresponding to the codes (16AA, 1; 16AE, 2...) sorting by that column then hiding it the desired result was accomplished. To refresh the sort after adding data, unhide the column and sort again.
Here are the steps:
Create new column to the left of the "Code" column.
Add a formula to extract the proper number for each code and copy down.
Formula: =INDEX (Group::c, MATCH (B, Group::A))
(Using INDEX(MATCH) is a good way to get column data with out worrying about extra columns being added as is the case with VLOOKUP.)
Result:
Best Answer
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: