Font colors

R

RoyR

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
 
B

Bob Phillips

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)


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
 
R

RoyR

THANK YOU VERY MUCH!!! That seems to have fixed an annoyance that has plagued me for years. Thank you!!!!!
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)


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
 
Top