colors

I am new to VBA and want to create a macro which will add conditional formating to the columns which I insert. I need each row to be formated the same. I want it set up so that if the row (D4:D29) says borrow it highlights the highest rate. If it says lend it highlights the lowest rate on that...

Is there a way to use a formula to count or sum only cells in a column that are hightlighted (filled) a certain color?

In my macro, I utilize conditional formatting to create alternating rows of color. The powers that be have tired of the sage green I've been using. How do I easily change the color in the following piece of code? Say I want to change it to pink, and then later on I change my mind and want to set...

I am needing the silver and Gold colors. Do you no how I can find or how to create these???

Need help to calculate the contrasting colors for given set of RGB values. For a <code> sub contrast() r=127 g=127 b=127 activecell.font.color=RGB(r,g,b) new_r=255-r new_g=255-g new_b=255-b activecell.interior.color=RGB(new_r,new_g,new_b) end sub </code> does not help when r,g,b values near...

Hello all, I have been searching online for a decent block of code that will tell me the RGB value of a cell's color, but cannot seem to find a one. I have a spreadsheet that has a few columns with conditional formatting. I just picked the standard color options Excel 2010 gives. Now, I want...

Hello!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> Can somebody help me out with some VBA solution for my below problem:<o:p></o:p> -I have two columns<o:p></o:p> -In column »A« are listed values in black and red font color<o:p></o:p> -I...

I'd like to apply some fill colours to a grid which represents events (in rows) and dates (in columns) to make it easier to distinguish entries. I have manually applied fill colours to the columns. For the sake of argument, alternating columns are in one of three shades of grey. I would also...

Hello All, The code I have written is intended to insert a variable number of rows underneath(or above) each existing row based on the number of yellow cells. I have borrowed Functions from cpearson.com to count the number of colored cells in a range. I keep getting stuck on the line that is...

Hi all, I want to create conditional formatting that is quite simple - but I'm not very Excel literate and can't seem to have the patience to figure it out! All I want is for each cell in a column to be shaded a color for easy viewing. Red for negative numbers, yellow for zero, and green...

Hi, I'm trying to color some datapoints in a scatterplot based on the color in the neighboring cell where the data is. I've written some code, but I'm not sure why it's not working. I don't get any errors, but the datapoints do not change color. Basically I recorded myself selecting a...

On VBA, how do you make half a graph one color and the other half of the same graph a different color?

Hi all, I want to format my spreadsheet based on the adjacent value in the previous column according to three color schemes. I'd like to have the cell in column B turn green if the cell value equals the value in column A. I'd like the cell in column B to turn orange if the value is an...

Objective: Find a specific color in the color palette given a "Pantone". For example, I'm looking for a Blue hue with pantone = 646 C.

Hi, fellow Excel designers, I've been searching the net for the entire day now. I'm looking for an easily analysable timeline. For example, this is how my data looks like: It shows each entire day and the events that happened on that day in accordance to a conveyor belt where products are...

I have been searching for hours now and while I can find tons and tons of information on how to do conditional formatting to CHANGE a color, I can't find what I'm looking for. Is it possible to write a formula where the color of the cells background (or text, I'm not too picky) determines what...

What would be the best way to go about coloring every 17 rows (rows 4:416 - columns C:V), skipping a row in between each 16 rows. Need the background color to be blue. So basically - every 17R x 20C should be blue skipping 1 x row in between each set of 17 rows from row 4 to row 416...

I am in charge of inventory for various pieces of computer equipment. My office loans out equipment on a daily basis. I would like to either write some code or a macro that will fill a cell with a certain color (like red) if an item is checked out based on a specific value in a cell. For...

Hello I have a range of data which I want colour-coded if the date in a cell is different to the one above it. If it is the same as the date above it, I want the colour to be the same as that cell. The below macro almost works - it scans the range, and if the cell above it is different to...

Hey everybody I have a large schedule where each row is sorted by the First date (already doing/done) but as there is a lot of data, we want to be able to colour the cell rows for each sequential date on the schedule. So the first row starts at 6, the column with the date in question is "G"...