This is kind of a two-part question.
- Is it possible to create conditional formatting to highlight an entire row with a certain color based on whether the checkmark object in the row is selected? For instance, in the example below, if "Rename URL?" is selected for a certain row, the whole row would be changed to a different color.
- Assuming the above is possible, is it possible to go one step further and have different colors override each other if subsequent objects are checked off in the same row? For instance (again, referring to the example photo below): If "Rename URL?" is checked, the whole row would be orange. But if "Redirect Built" is checked, it would override that and color the whole row yellow. If "Page Built" is checked, it would recolor the whole row green.
I’m kind of at a loss on this one, so any help you can provide would be very much appreciated!