Mar 7, 2016 · Hey guys, EDIT: I was able to figure this out already with conditional formatting (or at least using green, yellow, and red colors). In column E of my "to do list" spreadsheet I have ranked …

Mar 27, 2016 · The colors 1-16 are widely understood color names from the VGA color palette. Of the 56 colors only 40 colors appear on the palette. The 40 colors names indicated on the Excel color palette …

Nov 9, 2015 · Hello, I am trying to simplify a data set where I have highlighted the relevant columns. I have used this code before with great results: Sub Hide() Dim cell As Range For Each cell In …

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 …

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).

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 …

Oct 3, 2022 · I need help to convert ColorIndex to RGB value cells.Font.ColorIndex = 5 how to get RGB value of 5 using vba ?

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 …

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 1, 2002 · This is an easy task using Conditional Formatting. This feature was introduced in Excel 95. It allows you to specify up to three conditions and to automatically change the cell formatting based …