1. B

    detect location of a color

    Hi everyone, In my beautiful Worksheet, I need to know between which city there is a green bar. I explained : for the first line I need to know that there is a green bar between "Lyon St Priest Coque A1" and "Delandine", and between "Delandine" and "Lyon St Priest Coque A2" the second line ...
  2. G

    Change shape color by row to specified color

    Hi folks, I have a simplified timeline example in the attached image below to illustrate what I am trying to do. For some reason XL2bb isn't working for me to put the mini-sheet in. With a macro, I would like to recolor any shape that is in a row marked with an "assign color" (C2:C6) entry. I...
  3. S

    Colorize cells with comments that have specific word (Conditional format)

    Hi. I used VBA code from this post and it working good, but have one problem... Function CommentText(Cell As Range, Txt As String) As Boolean Dim x As Comment Set x = Cell.Comment If x Is Nothing Then CommentText = False Else CommentText = x.Text Like "*" & Txt &...
  4. M

    VBA Expiry date with entire row Color highlight & new column with status

    I'm trying to write a VBA CODE example mentioned below. Help on the below-mentioned example A B C D SL NO PRODUCT MANUFACTURING DATE EXPIRY DATE 1 ABC 01-01-2021 01-01-2022 2 XYZ 29-03-2021 29-03-2022 3 CDA 04-05-2019 04-05-2020 4 TWC 23-03-2021 23-03-2021 I want my output as...
  5. D

    Coloring of different shapes based on time

    Hi There, I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this. I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...
  6. S


    Hello, I need code for data validation to set color in the cell In the picture I explained Thank you in advance for your reply
  7. 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...
  8. 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...
  9. 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?
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. S

    Changing excel's scroll bar color?

    Can i change excel's scrollbar(s) color? I have 2016, on Windows 10. Thanks!
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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