I use a good size Excel spreadsheet with a couple worksheets. I use this to track my time and expenses for jobs I work.

I use the colors to keep track of rows that are "active jobs" (black), billed and awaiting payment (green) paid and done (red).

The problem is that when I enter a new row of info, it's automatically colored the same as the previous row. I would rather have the new row default to black. Is there a way that I can change some setting to keep Excel from copying the color from the previous row?

Thanks.
Roy