Benches Uncategorized

5

Formulae to change cell colours automatic…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

First of, let me state that I know conditional formatting can let me automatically change a cells colour based on the information stored within that cell.

What I don't know how to do is change the colour of a cell based on the information in another cell in that same row.

In my example I have a check box in one row of my spreadsheet. When one cell in that row of checkboxes is checked I want another cell in the same row to change colour.

Is there a way to do this?

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    Badunit

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Here is the typical way to do it. It requires one additional column. You will hide that column after you get it all set up.

    Formula in cell H2 =IF(G2,$A2,"Do Not Highlight")

    You may need to use semicolons instead of commas in the formula, depending on where you are.

    Fill down to complete the column

    The conditional format is shown in the screenshot.

    Fill down to give the entire column the same format.

  2. 0

    sheakun

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thanks for your reply Barry and sorry I didn't make myself clear enough.

    Essentially what I'd like to do is this (using the picture for reference). If the checkbox in row 1 is ticked, then the header cell containing the date, in row 1, will automatically turn green.

    If I tick the box in row 2, then the header cell for row 2 turns green.

    Checkbox in row 3, then the row 3 header cell changes colour.

  3. 0

    Barry

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    As you are aware, conditional highlighting rules compare the data in the cell to be highlighted with ether a fixed value, written into the rule, or with the value in another cell.

    In my example I have a check box in one row of my spreadsheet. When one cell in that row of checkboxes is checked I want another cell in the same row to change colour.

    This description is ambiguous.

    You have "a checkbox" in "one row" of a table.

    When "one cell" in that "row of checkboxes" is checked, you want another cell in the same row to change colour.

    I'm assuming the second statement is more accurate than the first regarding quantity. You have several checkboxes in a row, not just one.

    Do you mean 'when a specific cell in that set of checkboxes is checked' you want a specific cell in the same row to to be highlighted,

    or do you mean 'when ANY cell in that set of checkboxes in checked,' you want a specific cell in the same row to be highlighted,

    or do you mean 'when only one cell in that set is checked' you want a specific cell in that row to be highlighted?

    What if more than one cell in the set is checked?

    All of these are possible, and each requires the same general technique, but differs in the details from each of the others.

    The general technique is to provide a 'partner cell for each cell that is to be highlighted, then to control the value in that cell using the content of the checkbox(es) which is/are to determine the highlighting applied to the cell.

    Provide more specifics, including a screen shot showing row numbers and column letters of the cells involved, and it's likely we can provide a solution.

    Regards,

    Barry

  4. 0

    Barry

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    (removed by author—duplicate)

  5. 0

    sheakun

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Awesome, I've got it working. Thanks so much.