Conditional formatting would work, but it might give you a lot of fragmented rules if you copy paste a lot. I use the below number format:
if you want this for the transaction sheet, apply this to the whole row except the header, and because of the way transactions are added when filled it’ll keep that formatting.
but either way works depending on what else you need and how you interact with your file