1. N

    Conditional Formatting Color Codes

    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...
  2. S

    Font colors sensitive SUMIF

    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...
  3. S

    How to darken or lighten an existing fill colour?

    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...
  4. M

    VBA insert variable number of rows based on yellow cells in single row

    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 to count the number of colored cells in a range. I keep getting stuck on the line that is...
  5. P

    Tri-Color Conditional Formatting

    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...
  6. L

    Help Custom Color ScatterPlot Points with VBA

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

    Colors on VBA

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

    Colorful Conditional Formatting Question

    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...
  9. B

    Identifying Colors

    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.
  10. D

    Timeline analysis

    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...
  11. T

    Conditional Formula BASED on Color?

    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...
  12. C

    Color Cells based on Loop

    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...
  13. V

    Want to do take an inventory spreadsheet to the next level

    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...
  14. ClimoC

    Please fix my macro quickly!

    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...
  15. ClimoC

    I don't think I'm doing thsi right. VBA to colour rows

    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"...
  16. Jaafar Tribak

    Cool MultiColoured ListBox !!

    Greetings, Download workbook demo Ok, this is a raw experiment and needs some more tweaking .The main issue is if the Listbox has a scrollbar ,the painting will not fit exactly as it should. This is because the listbox scrollbar has no hwnd so it's very difficult to manipulate it...
  17. C

    Multiple Color Labels on X-Axis

    I believe I have seen before where you can set your X Axis labels to be formatted in different colors. For example, I have a listing of inventory by block, B1 - B10, and if the block has more than 500 in inventory I want the axis label to be red, otherwise I want the axis label to be black. So...
  18. L

    Pivot Chart Fill Colors

    I am trying to make a stacked column pivot chart with about 15 pieces. The chart will only allow 8 colors then start repeating. When I manually update the colors, the formatting is lost when the pivot chart is changed. How do I allow more than 8 chart fill colors?

Some videos you may like

This Week's Hot Topics