I did something (sorting? filtering? adding manual transactions?) on the Transactions tab that messed up formatting for certain rows only. I was able to fix the lack of a dropdown in the Category column by resetting the data validation to D2:D1, however, the same certain rows are still showing with white font and blue background, just like the header row.
I did check conditional formatting for the sheet and it doesn’t show any rules.
Does anyone know what I might have done and how to fix it? Thanks!
My guess is this was caused by selecting row 1 followed by insert row below. The new row inherits the same formatting as the selected row.
One option to fix it is to select the entire sheet and Ctrl+click row 1 to deselect row 1 and set the text and fill colors to the following original template values.
If there are no conditional formatting rules in play, then resetting the format like @Mark.S suggests above would fix things.
Another way to highlight everything below row 1 is to enter A2:Z in the cell selection box, changing Z for the final column in your Transactions sheet, then hit enter.
