1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. S

    Changing excel's scroll bar color?

    Can i change excel's scrollbar(s) color? I have 2016, on Windows 10. Thanks!
  8. 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...
  9. 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.
  10. 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,
  11. 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...
  12. 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...
  13. 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"...
  14. 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...
  15. T

    conditional formatting

    Hello, if the delta between cells H2 and J2 is >=2% color cells red. thanks in advance
  16. C

    Excel to Visio - Shape text color

    I am creating a Visio diagram from the data in excel with VBA. My data has a column of names and a second column of addresses. I am able to drop the shapes into Visio and specify the shape (circle, square, etc) based on the name. I am able to put the name on the shape text. I need to change the...
  17. C

    Cell Color

    I have a workbook that gives me a number depending on cell color using Define Name. I named it GetColor. I used a previous post in MrExcel to do this. When I change the color, the number does not change automatically. What am I doing wrong? =GET.CELL(38,Sheet1!$B$2) This is what I am using...
  18. D

    Color the cells based on notepad color code

    Dear All, My name is Dusan and this is my first post in the forum. I have been using it for quite some time now, and the reason I am boring you with this question is because I have not been able to find the answer anywhere... Here it goes: I have 50.000 lines in the .txt file (50.000 different...
  19. M

    Excel 2016 color pallet number

    I'm looking for a way to determine the number of the color set to cell. I have a macro that loops through creating a column of cells with the number background color... But I can't seem to find the corresponding color from the fill drop down. I have a table and use the color number to set the...
  20. D

    Conditional Formatting with two values

    <tbody> 123456 Murdock 123555 Murdock 123456 Murdock </tbody> I'm trying to get the first and the third rows to get filled in a Color since both the ID and the Name are the same value. The second row should not be filled. Any ideas?

Some videos you may like

This Week's Hot Topics