You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I am making a stock spreadsheet and I have 3 categories for my stocks. The are conservative, moderate and aggressive. I want to be able to type either C,M or A into the first cell of a row, and the whole row will change to one of three colors. Thanks
iPhone 12 Pro Max
Hi Scrubber2,
As Olivia said, it can be done with auxiliary columns. Here is an idea using auxiliary tables, and it does simplify the process.
Insert a table for each category, C, M, and A
Give each table the same number of columns as Table 1.
Formula in Table C, A2 is IF(Table 1::$A2=A$1,Table 1::A2,"")
Fill down and fill right.
Copy Table C, A2 and paste into Table M, A2.
Fill down and fill right.
Paste into Table A, A2.
Fill down and fill right.
Conditional Highlighting: Select all the Body Cells in Table 1
Hide (Cut and Paste) the auxiliary tables on another Sheet.
Please call back with questions.
Regards, Ian.
You can also do this quite easily with just one table and a few helper columns (one helper column for each distinct color), like this:
In G2, filled right and down:
IF($A2=G$1,"~","")
Use ; instead of ; in the formula if your region uses , as the decimal separator.
Then select the cells in the rows (not including the helper column) and add Conditional Highlighting rules like this:
Be sure to "anchor" the references within each rule by clicking the token and doing this:
SG
You can use conditional highlighting to color the cell. However, conditional highlighting only affects the cell to which the rule is applied. It cannot automatically extend to the entire row.
You can select the first column, and then go to Cell -> Conditional Highlighting, and add three rules (I randomly chose three colors), as shown in the screenshot below.
If you want to highlight the entire row, you may need to add auxiliary columns, which could be a great deal of work.
Hi SG,
Excellent solution! I was struggling with Badunit's "Text does not end with ~" approach when adapting to multiple categories (Column A). You nailed it!
Also, your answer removes the need to add rows to my auxiliary tables as new rows are added to Table 1.
An upvote for you!
Regards,
Ian.
Thank you, Ian, for the kind words about a solution built on Badunit's original insight! It's still too hard to do. It's been a recurring question all the years we have been together in this forum. Perhaps some day Apple will engineer a way to make it easier to highlight whole rows.
SG
In Apple Numbers, can I make a row change colour based on what I enter in a certain cell?
