rgb

First time post. Please excuse any indiscretions. ' I want to set Selection.Font.Color using RGB values, which are stored in a cell in a different worksheet ( e.g., RGB(0, 102, 204) ) ' Here is some of the code Dim DataWorksheet as String Dim SelectionFontColorCell As String Dim...

Hi everyone, I am using excel 2007 and need to use pie charts for a presentation. My boss insists on using one of the pre-set styles ("Chart Style 11", a lot of shades of blue). However, I need to manually create a legend in powerpoint using text boxes, and I'd like to fill in the text boxes...

Hi, (Note: I am using Excel 2007). I have a big range of cells on 'Sheet 1' that I have conditionally formatted. On 'Sheet 2' I have a table with the same column and row names as 'Sheet 1', but no data. In this table on 'Sheet 2' I want to put the RGB color (if possible in format RRR, GGG...

I have a worksheet containing rectangle shapes being used at buttons. Clicking the shapes points to different macros that change data on another sheet. The macro also changes the color of the shape to indicate that it has been clicked "ON". Clicking the shape again would again change the data on...

Hi peeps, I am using a row of autoshapes to show a key underneath a macro-cotrolled map made of other shapes, whose colour depends on various values. There is column of data for the key with ten rows; one for each shape in the key. This column of data holds RGB values for the shape colours, in...

Hello, I need to verify if a cell has a specific RGB color, for example [204,255,204]. The tricky thing is that I am not allowed to use Macro, VB,... Is there a way to verify it? Theoretically i thought about some ideas: verify the color against another cell (both have the same RGB value)...

Hi Guys.... I'm trying to find the RGB value for a standard Excel 2010 colour - the grey background colour for a Form. When I look in the Properties window, it's specified as "&H8000000F&". Assuming the "&"s are field delimiters, and "H" indicates Hexadecimal, the Hex value is 80 00 00 0F. I...

I have a table of data which has quite afew columns. I find it easier to read the columns if each row is a slightly different colour, (white and a very light grey is my normal preference). Now, the table I have at present is one I have inherited. Some of the columns are coloured light yellow...

Hi guys This works fine as a macro, but when I tried sticking it in a module, saving it as an add-in, and using it in the worksheet, it fails with a non-descript 1004 error. Public Function HexColour(ByRef Rng As Range, Ar As Range) Dim myScale As Double Dim Av As Double, Mi As Double, Ma...

Hello All, I have been scouring the boards for a solution to my problem and I have found a similar problem and solution but it is does not work with my specific case/workbook. I have a program created in XNA .net framework which will take an image and break it down into individual pixel RGB...

This will proabably be an easy one for somebody... THe BackColor property on a UserForm is "&H00CFF3FF&" . Can someone please explain what that number means and/or what format it is in. :confused: I need to match that color and I am color-blind so I rely on the color values to help me do...

I've read Excel Help files (HELP!!!) :eeek:, and have searched this board and cannot find examples of what I am looking for. I have a file with around 120 charts. The file was created in Excel 2007 (Compatability mode), so users with older versions can view the information. Excel 2007...

Hi, I have a simple Pivot line chart with half a dozen series. On the maximum value data point on each series I have a data label showing the category name. I want to format the data label to match the line, e.g. Series1 has a red line (from the standard Excel design/style) and I want to...

I do not understand the use of RGB color codes. How can I get different shades of blue and green? In what way should I use those codes from 1-255 to get different shades?