Solved

Excel fill color palette mixed up

Posted on 2015-02-24
4
114 Views
Last Modified: 2015-03-02
For some reason, the fill color palette is not working properly. Under theme colors you would normally have different colors from left to right and lighter versions of the same colors from bottom to top. In this case, however, the colors are all mixed up. There are some blues where the yellows should be, some greens in some of the black positions, red in the white, etc. I have tried uninstalling Microsoft office, rebooting, and then reinstalling office but that didn't help. The system is windows 7 x32 with Microsoft office 2013 installed. All software updates are installed, and have ruled out any kind of malware. Thank you for any suggestions.
0
Comment
Question by:neptuneit
  • 2
4 Comments
 
LVL 22

Assisted Solution

by:rspahitz
rspahitz earned 250 total points
Comment Utility
This may seem like a silly question, but have you tried using different themes?
When I go to PAGE LAYOUT tab, I can pick lots of themes, then when I go back to HOME tab I see different color choices in the Font foreground color...although I don't see them scattered the way you describe.
0
 
LVL 31

Accepted Solution

by:
Rob Henson earned 250 total points
Comment Utility
In Excel Options choose the Save option from the left hand pane.

At the bottom of the right hand pane there is a button for colours. Click on that and a copy of the palette appears. One of the buttons on the right hand side is Reset.

Does that sort the problem?

Thanks
Rob H
0
 
LVL 1

Author Comment

by:neptuneit
Comment Utility
Thank you for the suggestions, but I'm afraid the issue is still present. I tried changing the theme and I also tried the reset button. Any other recommendations?
0
 
LVL 22

Expert Comment

by:rspahitz
Comment Utility
It's probably not going to help but did u check the Windows color theme ? Maybe there's a conflict there with certain themes overriding the Excel theme?
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now