Cell fill color changes by itself

I have a user who has excel worksheets that they use fill colors.  These are 
colors that they use all the time.  Suddenly when she opens the sheets, the 
colors change by themselves even though no one has changed them.  When 
another user opens the same document, they are the correct colors.  It seems 
random as sometimes the document shows the correct fill colors.
0
Utf
4/14/2010 10:54:01 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
954 Views

Similar Articles

[PageSpeed] 55

Reply:

Similar Artilces:

Can't display all text in cell
I'm trying to display text in a cell. I've got Wrap Text on, and I hav several paragraphs of text. All of it appears in the formula bar, bu not in the cell displayed on the screen. And yes, I increased the ro height, but it still doesn't show. Any ideas? Thank -- Message posted from http://www.ExcelForum.com I am having the same problem. Apparantly there is a 1024 character limitation per cel in excel. The only advice I have received so far, which does work, is to press alt+enter to create a line break. If you find another work around, I would be interested. Hi besid...

Changing start date
Scenario: In OL 2003, I have an event that's two weeks long, starting June 1 and ending June 14. I want to change the start date to May 27 but leave the end date alone. If I change the start date, OL automatically changes the end date to preserve the two-week duration. Is there a way to change the start date without affecting the end date? Richard Evans <infodex@mindspring.com> wrote: > In OL 2003, I have an event that's two weeks long, starting June 1 and > ending June 14. I want to change the start date to May 27 but leave > the end date alone. If I change the s...

Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or Query into specific cells of a Worksheet. The table I'm importing will always contain a single record only. For example, I'd like to export data from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc. Any sugestions would be most appreciative. ...

Conditional Formatting
I have a row of cells that calculate the totals for their columns but I force to be blank via IF statements until certain conditions are met. Once these conditions are met, the total appears. I'd like to also highlight these total cells via conditional formatting. My conditional formatting input is simply "If Cell is Greater than 0, format". For some reason all the cells format as though they are all > 0 yet they don't display anything. Are there some internal rules that specifiy when a cell is really 0? Is there another way to do this that won't care what the for...

Excel document changes format
Hi, I have an Excel document that changes format unexpectedly. It seems to change the format of the document eventhough i saved it. I have to resize the windows of the bar graphs, etc. It just doesn't save it the way i want. I re-installed MSOffice and re-did the NT profile, but still persists. Any ideas? Thanks. Excel does seem to have problems if the screen zoom is anything othe than 100%. Usually changing to 100 and back resets he screen display -- Message posted from http://www.ExcelForum.com ...

Hotkeys for text & background coloring
Hi. Does anyone know the hotkeys for text coloring (font color) & background coloring (fill color)? Eg: First you need to select the font color & fill color in the related toolbar incons. - When I highlight "I am great", then press "Ctrl+O" for example, the text will be colored as what it's displayed in the "font color" toolbr icon. - The simliar way applies to background coloring If the above is not available, any workaround is still apreciated. -- Additional information: - I'm using Office XP - I'm using Windows XP You could use a sma...

VFW webcam
Hi, I'm using Video For Windows to capture images from creative webcam in my application. This is giving me image in size 640x480. However, i need image in landscape resolution where width is less than height. I tried to squeeze the captured image but its distorting it badly. Any ideas how can we capture images from webcam in desired resolution? Thanks, neo see the amcap sample in DirectShow SDK -- Regards Sheng Jiang Microsoft Most Valuable Professional in Visual C++ http://www.jiangsheng.net http://blog.joycode.com/jiangsheng/ <dhapola@yahoo.com> ???? news:1160125564.284431....

counting same text from different cells
Hi I was Trying to count text such as "p" for pass from different cell in excel but i am not sure what is the formula for that. It will be really helpful if u could send me the solution thank you om Hi =COUNTIF(A1:A100,"p") -- Regards Frank Kabel Frankfurt, Germany "om" <om@discussions.microsoft.com> schrieb im Newsbeitrag news:96B25715-6B88-40F8-8360-9602A05E3B30@microsoft.com... > Hi I was Trying to count text such as "p" for pass from different cell in > excel but i am not sure what is the formula for that. > > It will be rea...

pulling cell "value"
in the cell C4 i have the formula =now() and I have that cell formatted to custom mmmm so that it displays as January. I am now trying to write some VBA code to look at cell C4 and take the January and then do a vlookup on the array that i have named months. months is the cells D14:E25 column D has a list of the months and column E has a list of numbers that corresponds to these months. This is a custom list so I can not use the standard numbers that excel uses for the months. The vlookup in vba should take the January and find the number in col E that corresponds to it th...

Formatting Cells #13
If you want something from cell (A) to appear in cell (B) and change when the contents of cell A changes, how do I do that? Acurran, =A1 ??? -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003 ** remove news from my email address to reply by email ** "Acurran" <Acurran@discussions.microsoft.com> wrote in message news:E800CB99-E6BA-4DF3-BCA0-445A89B2E8A8@microsoft.com... > If you want something from cell (A) to appear i...

Getting Combo boxes to change options based on other Combo boxes.
Using Excel 2007. I am trying to create either Form Control Combo Boxes or ActiveX Combo Boxes that will change the selectable options based on selections made in previous combo boxes. I am having a hard time finding any information that will work for me. Can someone tell me how to make 5 combo boxes change available listed options when specific options are selected in another combo box? Please? I've been working on this for a very long time without success. I've tried using Data Validation, but my formulas are too long for all the different possible combinations. You are...

change font size of first character
I have a template that allows users to print business cards. It displays a form where they enter their name and three other lines of text. I would like to increase the font size of the first character in each word if the user enters the text in upper case. The code I'm using to capture the text from the form is: With ActiveDocument For intLoop1 = 1 To 10 .Bookmarks("Name" & Right("0" & intLoop1, 2)).Range.InsertBefore txtName .Bookmarks("Title" & Right("0" & intLoop1, 2) & "a").Range.InsertBef...

Hard return in wraptext cell?
Is there a way to place a hard return(carriage return) in a cell with wrap text format so as to align text in the way user wants rather than what excel places? Thanks Mark Sure. Where you want a new line just press Alt+Enter. To remove that just place the cursor at the end of the line before the new line and press Delete Tyro "MP" <NoSpam@Thanks.com> wrote in message news:OAFfO3vVIHA.4880@TK2MSFTNGP03.phx.gbl... > Is there a way to place a hard return(carriage return) in a cell with wrap > text format > so as to align text in the way user wants rather than wh...

Highlighting a cell
I would like to highlight a cell for data entry, but I do not want the color to print. Is there a way to acheive this in Excel 2000. Thanks Sandi <File>, <PageSetup>, <Sheet>tab, Under Print, check the "Black & White" box. HTH, RD ==================================================== Please keep all correspondence within the NewsGroup, so that all may benefit! ==================================================== "Sandi" <ssteines@abprocess.com> wrote in message news:00c601c376eb$2b9a9910$a301280a@phx.gbl... I would like to highlight a ce...

change the color of non-printing characters in this version of Word?
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) How does one change the color of non-printing characters in Word 2008 12.2.3 for Mac?? <br><br>In previous versions, the non-printing characters were greyed, in the new version they are blue and are a *huge* distraction. <br><br>Thanks You can turn the Off by clicking the "=C2=B6" to turn them on click it ag= ain. KW@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) How does > one change the color of non-printing characters in Word 2008 12.2.3 fo...

How do I change the inverse colour in an Excel chart?
I want to have blue bars when the values are positive and yellow when they are negative. I have checked the box for "invert if negative" when choosing the colour in Format Data Series, but I still get blue for both. David, The concept described here should work: http://www.pdbook.com/index.php/excel/conditional_column_chart/ ---- Regards, John Mansfield http://www.pdbook.com "david_hutton.NO_SPAM" wrote: > I want to have blue bars when the values are positive and yellow when they > are negative. I have checked the box for "invert if negative" wh...

in MS EXCLE how we can protect only one cell?
plz do repl me soon Hi First select all of the cells in the Sheet>Format>Cells>Protection>remove the check mark form Locked. Next select the single cell you want to be locked>Format>Cells>protection>check Locked. Tools>Protection>Protect Sheet (optionally provide a password - remember to write it down somewhere of you do) -- Regards Roger Govier anu khan wrote: > plz do repl me soon EXCEL 2007 This assumes that you wish to protect cells D 83 to D 85. If you wish to protect just one cell replace D 83 to D 85 (below) with the cell ...

conditional formatting colors
I need to somehow reflect drops in collections, but there is no set beginning amount to put in the formula bar. I need to highlight in bold or color decreases on a monthly basis and by quarter when drops of three consecutive months happen, I have tried everything, but nothing seems to be working. The spreadsheet is setup where as follows: a b c d e f g H name tume state desc rep month revenue collection it continues down with all of Jan. going down from column a4:a310 and then skips rows and begins Feb. stats a312:a624 and so on. I'...

Lists
I have a user who is importing an excel spreadsheet into a Sharepoint List, but some of the column types that SP is selecting is incorrect. I can't find any place to change the type of these columns (like from text to text with link, etc). Is this possible? Yes, you can change the column type after importing. Just go to the list settings page and choose the column you would like to update. The very first section of the column settings page will be for the data type of the column. -RH "J. Belcher" wrote: > I have a user who is importing an excel sprea...

Selecting Cells with Shift Key
When I am selecting cells in Excell, I use the shift key and the arrows on my keyboard. If I pause at all, the selection is lost when I continue with the selection. Why? Can anyone help me? If you have removed your finger from the shift key then Windows will think you are starting a new selection. Just be sure that you don't touch the arrows without the shift being held down. LWhite "Jaymndad" <Jaymndad@discussions.microsoft.com> wrote in message news:961E850D-AFAD-444C-AB81-F4A609BCB3BA@microsoft.com... > When I am selecting cells in Excell, I use the shift key...

Merge Cells, but keep backgrounds
In excell 2003 is there a way to merge cells so the text spans them all, but keep the current background of the cells (which are not all the same color)? No Try Center Across Selection and avoid merged cells whenever possible. Gord Dibben MS Excel MVP On Sat, 30 May 2009 09:16:12 -0700 (PDT), "dan@danirwin.net" <dan@danirwin.net> wrote: >In excell 2003 is there a way to merge cells so the text spans them >all, but keep the current background of the cells (which are not all >the same color)? Is there a way to center across selection vertically or just horizonta...

how do you chang language in excel
I have a swedish version of office 2003 it is in swedish but i speak english, can anyone tell me how to change it to english, other than having to go out and buy the english version. "peter curran" <petercurran17@eircom.net> wrote >I have a swedish version of office 2003 it is in swedish but i speak > english, can anyone tell me how to change it to english, other than having > to go out and buy the english version. That's a good way. In fact, it's the only way. -- Bob http://www.kanyak.com ...

Linking columns for auto fill
Can I link two columns to auto fill Column A when corresponding data is entered in Column B? In A1 enter =IF(B1="","",B1) Copy down column A as far as you wish. Gord Dibben MS Excel MVP On Thu, 25 Mar 2010 09:11:01 -0700, Daisy <Daisy@discussions.microsoft.com> wrote: >Can I link two columns to auto fill Column A when corresponding data is >entered in Column B? ...

Can my form fill in a field, yet allow me to override?
Each customers is sent to us from a salesman, and we provide service for 1-7 days before the activity ends. A new charge is generated for each day of service. Employee #1 uses the customer service form to generate a bill, and includes the name of the salesman. Employee #2 uses the form to generate a bill on the next day, and has to look up the first bill, in order to know which salesman to record. The same thing happens every day until the activity ends. With each new referral for service, there's a strong chance it will be due to a different salesman, so the customer number an...

Data Entry to a Cell Range
Can I set up a data entry form, so if every time I enter a value in a cell, it updates the next empty cell in a range? Thanks Lets assume that the form is used to update cell A1. We require that everytime A1 is updated the new value will be recorded in column B. Put the following event macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Dim A1 As Range, t As Range Set A1 = Range("A1") Set t = Target If Intersect(A1, t) Is Nothing Then Exit Sub Application.EnableEvents = False n = Cells(Rows.Count, "B").End(xlUp).Row...