![]() With the options left unchecked, each cell in the selection compares its value to that of the cell at the same relative location in E2-G10. Unlike its predecessor, Numbers 3 allows choosing to Preserve row and or column of the cell reference or not choosing to do so. Results can be seen in the cells of columns E, F and G.Ĭells B2 - D10 were selected, and the Conditional Highlighting Rule shown below was entered. The formula is filled down to the last row, and filled right to column G. If the cell in 'this row of' column A is TRUE (checked), copy the content of the cell in 'this row of' column B, if not, insert a null string. Shown at the right are the three column added to provide a cell for each of the custom highlighting rules to reference for comparison with the content of cells B2 to D10. Here's an update to include tables where that text may be in more than one cell. That solution was writen for a situation where the "the entire text on that line" was in a single cell. ![]() The third solution, which does use text colour change to highlight rows where the checkbox has been checked does apply the conditional formatting directly to the cells to be formatted, comparing each to another cell whose content is determined by the state of the checkbox on that row. The two solutions above using colour fill rather than text colour change will also work in the current version of Numbers, and will provide formatting that appears to have been applied to the whole row. ![]() The OP wants to apply the conditional highlighting to "the entire text on that line." That cannot be done setting a rule for the checkbox cell-the rule must be set for the cell(s) containing "the entire text on that line," and it must compare the content of that cell (or those cells) with a fixed value or with the content of another cell. ![]() What you've suggested will change only the fill colour of the checkbox cell.Ĭonditional highlighting rules compare the content of the cell they are applied to with a fixed value contained in the rule (as in your example "text is TRUE") or with the value in another cell. The three responses made (in 2012, when the question was 'fresh' and applied to the then current version of Numbers) all address applying formatting to "that line," two of them to highlighting using fill colour for the cells in the line, the other for changing the text colour in (one cell of) "that line." "How do i make it so when i check a checkbox and make the entire text on that line change color" ![]() What you've posted here regarding conditional highlighting is TRUE, and does what you say it will, but it doesn't answer the OP's question: Welcome to Apple support Communities, and the Numbers for Mac community. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |