Font colors

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

Roy,

Do you have Extend list formats and formulas set? You'll find a checkbox in Tools>Options>Edit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RoyR" <roy.rutherford@comcast.net> wrote in message news:NNWdnbgL2d0s8sjenZ2dnUVZ_sydnZ2d@comcast.com...
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

THANK YOU VERY MUCH!!! That seems to have fixed an annoyance that has plagued me for years. Thank you!!!!!
"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message news:%23ily7ID1FHA.1256@TK2MSFTNGP09.phx.gbl...
Roy,

Do you have Extend list formats and formulas set? You'll find a checkbox in Tools>Options>Edit.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"RoyR" <roy.rutherford@comcast.net> wrote in message news:NNWdnbgL2d0s8sjenZ2dnUVZ_sydnZ2d@comcast.com...
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