Change in font and color

[dberger16]

I have a spreadsheet and the font is all one type and color. Now I want to
add more data in in certain columns, but with all the new data i want in a
different font and color. how do i change the font and color for all of the
new data going forwards.

Thanks.

 

[Gord Dibben]

Select the cells you will be adding more data to and change the formatting.

You could do that automatically using event code.

Where do you currently have formatted data and where would you be entering
new data?


Gord Dibben MS Excel MVP

 

[dleo]

Event code might be a little difficult. I suggest you just enter in the data
as you would otherwise and then afterward, highlight what needs to be changed
and go to Format --> Cells.

 

[Gord Dibben]

Why do you consider event code a little difficult?

Would be easy enough to identify cells that are currently filled and any
newly filled cells would take on the new formatting.

Although I agree that simply manually formatting may be easiest method.


Gord

 

[dleo]

I meant that for beginners, event code might not be the way to go. Manual
formatting is a lot easier.