Jun 30, 2020 · I want to put the list into excel and then have the color of the HEX code print into a box in excel (so it will end up looking like a column of different colors based on my hex code).

Jul 21, 2005 · Hi, I have a need to color code a number of cells (let's say days) that matches to a duration field (that is calculated from the start and and the end date fields). Do I have to have a VBA …

Jan 28, 2014 · Ok I need some help with this. My background color on my spreadsheet is RGB (189, 215, 238) Hex#BDD7EE. When I go to the ActiveX properties box and enter &H00BDD7EE& I get a …

Dec 23, 2013 · Hi Everyone, Can someone please help me create or input a macro that will color-code cells in excel according to the following color-scheme (common in financial models)? Blue - Hard …

Apr 11, 2013 · That is the value for xlNone, but when applied by Conditional Formatting, it does not change the native color of the cell.

Nov 30, 2014 · Hi, I am often in the situation that I want to copy the cell fill color to another cell, without the rest of the format, like borders, fonts, etc...Oftentimes the fill color is not one of the standard …

May 24, 2021 · Hi hoping you can help me with this query. I've a range of cells =C35:M35 that have been coloured with various shades of red, amber, green, blue. In the row below i'd like to show the …

Jun 2, 2022 · Hi there, May I know if there's a VBA Code that can return the RGB colour code of a coloured cell? Thanks in advance! Best, SC

Aug 16, 2003 · Re: Pivot Table - Can I maintain cell color of original data Denis, I manualy apply 1 of 5 colors to the data in the work sheet. Then I create the Pivot Table (needing the color to come along …

Mar 27, 2016 · How can I list all the color code in the sheet so I can see which code give me this color or that. Is there any function or formula to transfer the number to name of the color for example 1 black …