1. O

    VBA: automatically give color to next cell in a list/column if different from above/previous (distinct)

    To enhance visibility when looking through a list/column of slightly changing codes I want to make sure my eyes see when a code has changed, by coloring the distincts. I want to: run a macro that gives my selection of cells a (unique?) (random?) color for each distinct cell value. Anyone have...
  2. B

    Sum of vlookup in multiple rows with condition

    Hi, Let me try and explain what I need with a simplified example: I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality). I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
  3. Y

    3D shape in pale orange color

    I created a 3D rectangular shape filled with pale orange color. However, the color of the edge is quite dark. I have changed every color I could find in the property but the dark color persisted. Any way to change the edge color?
  4. H

    Details of formatted cell

    Hello there I need some help with a problem: I have a table, imported by Copy/Paste function, like the one below: The values in column C and D are manually inserted, for the purpose of the problem. How can I get these values (Column C and D) in an automation mode (functions or VBA)? Many...
  5. D

    Count by Color and Date

    To illustrate the formulas I need I've attached an example of what they should return. Dates are entered into column A. Then the cells get colored grey once they are processed. B2 is supposed to show how many cells are in column A that have a date in them but are not colored. C2 is supposed to...
  6. S

    if cell is red then display a value from another cell on the same column.

    Hello, I have a time report where the weekends and legal holidays are autofilled in red if an employee is registered as working. Due to new legislation I need to keep a record of those days. I would like to auto check if every row(eg. F17:AJ17) has red cells and then paste a date from a cell...
  7. D

    Conditionally format cells to red color if cell 4 rows to the left is not blank

    Hello everybody, I currently have the following list: I want to create a formula (probably through conditional formatting i'd imagine), that basically says: If the cell 4 turns to the left of any designated cell (A1) in row E is not = blank, color the cell in row E with a red...
  8. K

    Charts changing section colors with slicers

    Hello! I have an interesting problem that I am occurring. I have created some charts that is looking at racial data through pivots. When using some slicers to within the data that I have, it takes away some of the racial information that is located. You can see with the images below. While...
  9. D

    VBA code or other solution to color cells white if they contain no data

    Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...
  10. D

    Conditional formatting (extended? or vba code?) for entire row

    Hello everybody, I am currently managing a worksheet containing a stock overview, which looks like this: I have made two conditional formatting rules which assert under my "Antal" (meaning Quantity) column that if the number is below or equal to 0 the color should be red and if the color is...
  11. A

    print HEX code as color in excel sheet

    Hello I have searched and attempted to implement many various macros to do what I am looking for, but I have not been successful. Could anyone give me an excel sheet that has the macro already setup for doing the following. I have a list of HEX codes I am using for a bar plot in R I want to put...
  12. D

    Conditional formatting based on row data

    Hey all, I am not sure if this is even possible, but I figured I'd ask/give it a shot. In a spreadsheet I have a marker (denoted in cells with a * symbol). Is there a way (without using VBA) to use conditional formatting to adjust the colors of the cells around the marker? The following...
  13. S

    Changing excel's scroll bar color?

    Can i change excel's scrollbar(s) color? I have 2016, on Windows 10. Thanks!
  14. S

    Sum by color background and if another condition

    Hello, I am trying to write/find a correct vba code able to sum the amount in a colored cell based on two conditions : the color of the background and based on another condition (here the fruit) You can find a easy table showing the situation : I want the formula to sum the amount in the cell...
  15. A

    Is it possible to have 2 different colors for a numeric cell?

    Hi, I have a numeric cell formatted as (#,##0 "Meters") to display --> e.g. 112 Meters Is it possible to display the text "Meters" in a different color? --> e.g. 112 Meters Thank you.
  16. T

    VBA - Find all the White Cells and populate them with a Random Value.

    Hi all, I am Junior on VBA and I can not make it with the below task. I have a huge worksheet with White and Grey Cells. My task is to find all the white Cells and Populate them with a Random value. Can you advise? Thanks in advance,
  17. DailyDrama

    Changing Font Color in drop down list

    Hi, i have a drop down list that i want to change the font color of based on the selection. Two out of three of my selections/Font color change work - but i cannot get "Amber" to work. I have "white" as the font colour - it works, but when i change the color to Amber or Orange - it doesnt...
  18. P

    Selecting cells by color in VBA

    I would like to select all cells in the dataset A2:F156 where the color index is 19 (light orange) or 40 (dark orange). I have uploaded a picture of my dataset below. I have compiled the following code: Sub SelectByColor Dim cell as range, rng as range Set rng = range("A2:F841") For each...
  19. P

    Conditionally format the last cell in each row with valuable data

    I have a dataset for wells and 5 treatment plants (TP1, TP2, TP3, TP4, and TP5), which extends from A1 to F841. The flow path for each well is such that the well flows to TP1, then TP2, and so on. However, sometimes the flow path does not extend all the way to TP5. I have manually entered "None"...
  20. M

    Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells

    I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back