colors

Hi: This particular issue relates to Office 2013, but I believe it also is current in 2016. We have common MS Office theme thmx files populating custom colors, which works as expected on PPT and Word, ie the formatting colour palettes contain three sections, Theme Colors, Custom Colors and...

Have a good day everyone! Problem : Row(s)/cell(s) automatically will be locked after filling colors I know this may sounds like a broken record , but i can't find previous thread about my excel problem. Can someone help me please..thank you in advance.

Hi, I am using excel 2010, and want to get the color integer value. I tried using Dim colornumber As Integer Dim c1 as Range Set c1 = Range("A1") colornumber1 = c1.Interior.ColorIndex But the problem is that "grey" has a "2" value and so does the white space, so it doesn't capture all the...

Hello, I'm trying to find a way to show the world map with all countries. I want to color all countries based on criteria will be 4 colors. Example of country colors - cleared (blue) - removed (red) - review (yellow) - approved (green) What's the best way to do this? I'm not opposed to...

I am using a user form to pull cell colors to allow a user to set custom colors for reporting. I thought I could use a for loop to set these sequentially but it doesn't seem to work. Is there a cleaner way of doing this? "Aspect_" & i & "_Col" = Cells(7,14 + i).Interior.Color does not work...

Hi all, I am trying to save filters so I can restore later and the logic that sets my criteria1 value fails with "1004 application or object defined runtime error" when the filtered column is a date. Has anyone figured a way to do this when dealing with dates? I also have a problem...

Looking for help in the following: Trying to move data in multiple rows in tab "Colors" to one row on "Summary" tab. Colors tab looks like this: A B C D 1 Red 1 2 2 Red 10 11 15 3 Red 23 150 256 4 Blue 5 6...

I have a search sub that highlights the area with yellow cell color. I remove it with the sub below. Can I remove ONLY the yellow cell color and leave all other colors there? Thanks Sub Remove_Color() Sheet4.Cells.Interior.Color = xlNone End Sub

Hi, We are trying to create a color theme to restrict the colors Excel to just our branded colors. I know how to change the first 6 colors in a series, but I don't know how to get Excel to stop auto formatting the rest of the colors and just force it to use our branded colors instead. I was...

I was working when all of a sudden my entire workbook turned grey, including the headers, toolbars, etc. Everything is still functional, but I can no longer use conditional formatting because there are no colors. (I can use the buttons and functionality, just can't see any colors anywhere.) My...

Can Excel recognize colors?

I am trying to figure out how to retrieve the theme color property from a bar chart. If I select a Bar Chart that has a fill color associated with a theme color and execute the following code: Selection.Format.Fill.ForeColor.ObjectThemeColor it returns a value of 0 (aka msoNotThemeColor)...

Currently my sheet uses alternating colored row. However when I insert a row and then resort my alternating colors break. Is there a code that will make this happen automatically, no matter how many rows I may insert. It is a list of names address's and phone numbers so I add 1 or 2 at a time...

Hi All, I have a rather big vba project that is used by multiple users. The different worksheets and userforms all have a uniform look and feel. Used colors are defined by RGB values. In my current code, the used colors are hard coded. For instance, the background of each userform is set...

Hello ! Is there any functional code (or other approach) which can count and sum all cells by "Conditional formatted" colors, on one sheet, and that the generated result is linked through common formulas? That can be updated/refreshed/run code during the work process as a complete overview...

is there any way to give colors for new sheets with macro?

Hello Forum Members, I need some help how to get an order form prepared. I have a worksheet full of data. In column A all the product names, col B has all the colors for each product available, col C has all the variations. Each on different row. I want to have another sheet where I could start...

I'm having trouble finding a solution to this problem. Basically, I build a bunch of workbooks for colleges and I like to have the colors match the school colors as much as I can. I can make themes for each school, but eventually I lock off a bunch of formatting functionality, so the end result...

I am running Excel 2016 with the latest updates, as is everyone else in my office. I created a spreadsheet for another engineer that will automatically calculate payment penalties for asphalt that does not meet the contract specifications per Michigan DOT standards. All of the macros and...

All our computers in the office currently run Excel 2016 on several different types of computers (Dells & HP's), however all operate with Windows 10. In the last few days each computer is experiencing problems with page layout view. It seems to be focused around conditional formatting using...