Worksheet Background and Font Colour

**Apple Ling** · 06-21-2009, 10:39 PM

Hi, when i pasted the data into an Excel sheet, the background will change to red and the font will turn to blue. Besides, the font in header will change as well. I can't find the way how to do it because this template is set by other person. I can confirm this is not done by macro. I hope anyone can tell me how to do it. Thanks

**mubashir aziz** · 06-22-2009, 01:32 AM

Have you check Conditional Formatting ?????

Just select one cell then Format > Conditional Formatting and check if there is some condition........

**Apple Ling** · 06-22-2009, 01:50 AM

I have checked the condition formating. There is nothing. The background and font colour will be changed if i pasted data to that particular sheet. If i using move/copy function copy to a new sheet, the colour will be different from the original.

**mubashir aziz** · 06-22-2009, 02:01 AM

Can you attached that sample sheet ????

**Apple Ling** · 06-22-2009, 05:32 AM

attached here with the file

**mubashir aziz** · 06-22-2009, 05:34 AM

Where is the file ???

**Apple Ling** · 06-22-2009, 09:18 PM

sorry i didn't notice the file not successful uploaded.

**mubashir aziz** · 06-22-2009, 11:40 PM

when i'm pasting data nothing happending. I've tried in several ways to paste the data but background is not changing ........ but i've noticed that there are some module which related to some pivot charts ???? Can you confirm that sheet changes background & font color only once or every time when you paste data ???? Did you try to clear all sheet and paste the data again ?????

**Apple Ling** · 06-23-2009, 03:00 AM

Yeah, the background won't change and remain as red. You can try to copy that sheet using copy or move function at the tab, then the background will change to yellow (original colour).
My question is how to set the background as default red. I have deleted all the macro and tried to copy paste again from the data source (yellow background). It's still red when i pasted to that sheet.

**mubashir aziz** · 06-23-2009, 03:10 AM

if you copy data from another sheet, then sheet colors changes ..... but while copy/move sheet color changes yellow and if you copy/paste data from that yellow sheet then it again changes its color ... This is a new thing for me as well .....might be some one expert will put some light on it ...... .....