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
