1. F

    Help with Conditional Formatting

    Hey guys. I've attached a portion of a spreadsheet I'm hoping to get help on. In cell E6 I would enter the time a particular incident was created. I'm looking to use conditional formatting to turn that cell red if the incident runs longer than 9 hours. Cell A3 has the =NOW() formula in it...
  2. ChloeLM

    Efficient formatting of specific cells by looping through...

    Hello everyone I'm a VBA novice who has muddled through a piece of code and got it working. However it's very long (and slow!) and i'm looking for some advice on how to make it more elegant (and efficient!) in order to speed up my procedure. Am i using an efficient way to loop through the...
  3. M

    Line graph - change colour if number decreases

    Good afternoon, I have some data already in a combo chart, a mixture of stacked columns and a line. The data for the line predominantly goes up in order, e.g. 1,2,3,4,5 However their may be some instances where the data will decrease, e.g. 1,2,3,2,1 I would like the line for the data where...
  4. D

    Auto formatting excel sheet using VBA

    Hi Guys, I am building a risk assessment form and need some help from the experts :D First would like the table to automatically add number in sequence if the cell risk is not blank as per table below. The same applies for mitigation and additional mitigation but with difference that...
  5. E

    Highlight Row and Column on cell selection

    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple sets of ranges. Ranges are E9:DA56 and E59:DA106 where I would like it to be active. 2) Only highlight or outline the cells above the...
  6. J

    Conditional Formatting Gone Wild

    I am losing my mind over this. I am very well acquainted with Excel; however, this super basic formula is killing me. Have I completely lost it?! We get a task on certain dates (DATE) and depending on the task, it may either have a 75-day suspense or 180-day suspense (STANDARD). To find out...
  7. Character7

    Non-unique Worksheet Identifier? Perhaps?

    Good morning. Quick question - doubt I will get the answer that I want, but this forum has proven me wrong in the past. I am currently working on a project with 2 display / hud worksheets, 2 data worksheets, and 6 - 7 client worksheets. I want to find a way, without putting a "identifier" cell...
  8. F

    Identify values from same column on multiple sheets

    I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help? Thank you!
  9. M

    Keep source formatting when pasting ranges to a shape

    Hi all I have a workbook with 2 different worksheets. In the first worksheet you type in different information. When clicking on the other worksheet the data from the first worksheet is then copied and pasted into shapes in the second worksheet. I have a challenge of keeping the source...
  10. L

    mm:ss formatting

    Does anyone have a solution to formatting mm:ss without the AM/PM after it. I'm creating a spreadsheet where I need to put time as an input, say for a race where something like 10:30 would be 10 minutes and 30 seconds. There are then some calculations done on the time which says if time is below...
  11. E

    Help with excel formula

    Hi all, I am having issues with the following formula: =COUNTIFS('Raw Data - Travel'!D2:D350,">"&'Total Summary Data - Travel'!B3,'Raw Data - Travel'!D2:D350,"<"&'Total Summary Data - Travel'!C3) Cells B3 & C3 are start and end dates. D2:D350 contains dates. The formula works perfectly...
  12. T

    Excel date vba filter

    Hi guys, Been stuck on this for days now so I'm resorting to asking for assistance on this one. I'm trying to filter between two dates in dd/mm/yyyy format ( my PC is formatted this way too in regional settings), but after I run the code, the date "custom filter" has mixed up the days and...
  13. freelensia

    Excel: cannot change alignment of a cell under conditional formatting

    Hi, I have a structured table with a certain table style: All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF. Furthermore, in column Good Listings I have some Conditional...
  14. F

    Best way to automate the reformatting of this?

    I don't know how to best deal with getting my example onto this post, so forgive the copy pasta. Below is an example of how my company's system exports reports in Excel (there is no CSV, or un-formatted option for export). So, the employee's name is sort of randomly inserted at the top of...
  15. T

    Cell format overrules conditional formatting

    I have formatted cells using conditional formatting based on a given value in my workbook being equal to either "EUR" or "USD". The custom format it should get when "EUR" is: "€"#.##0,00 (see screenshot 1). It shows the correct format (see below image), however when you would paste this cell...
  16. D

    Highlight cells with Conditional Formatting using large range of values

    Hello all, this is my first post. I’m having an issue with Conditional Formatting. I work in a warehouse, and I am having issues in a certain section of the warehouse with items being split across several different stock locations rather than being consolidated into 1 or 2 locations. There is...
  17. T

    Automatically copy cell formatting based on the formatting of another cell

    It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...
  18. E

    Formatting to last row

    I want to highlight cell b37 and until the last row (which might change) in order to format that range of data this is what i have so far, whereby i have declared at the very start of the code the following: Dim Lastrow as Long originally i had it as range("B37:B150").Select, but i had to...
  19. R

    Error on number formatting on VBA - Very Strange...

    1) I have an excel sheet with values (Numbers) that represent dollar amounts. 2) I have a Userform that has labels that update the values according to the amounts on the Excel Sheet... Everything was running smoothly until I opened the excel worksheet with a PC (I work on MAC Excel 2011) in...
  20. F

    Conditional Formatting based on an already Conditionally Formatted Column

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