I want to have alternating background colors for even/odd rows (better for the eyes) but also allow the user to override the background color if desired. AFAIK, there’s two ways–create an Auto format or use conditional formatting.
For my case, conditional formatting is preferable because Auto format carries over the formatting that was set on the row initially (e.g. creating a duplicate row right underneath an existing row would yield both rows having the same background color), whereas conditional formatting is dynamic where it formats the cells automatically.
However, it seems that conditional formatting has higher precedence than manually changing (direct formatting?) the background color of a cell that has been formatted conditionally, resulting in no changes to the cell unless the conditional formatting rule is removed.