formatting cells

  1. J

    Combining Sheet Data

    The title makes this sound simple enough but my problem is that the source information is live (shared through Office 365) and also formatted in a way that makes it tricky to combine. I have tried to get the people I work with used to a format that doesn't have date headers but they found this...
  2. A

    text filters vs date filters

    I have two Excel workbooks, one being a clone of the other, and each having multiple columns in which dates are populated by formulas. In my original workbook, I am able to filter each column using date filters (next month, this month, etc.), but in the second workbook, the only filter option is...
  3. Z

    Cell formatting behind a Pivot table

    I'm building a dashboards with Pivot tables and slicers. I have shaded the cells green, but when I click a slicer, the cells 'behind' my Pivot Table are white. Any advice on how to control this without VBA?
  4. E

    Cell autoformats when ":" is entered

    I have a Excel cell that has "1-1" in it. If I do a Find and Replace to change the "-" to ":" so I have "1:1" the formatting in the cell changes and will not display "1:1". I have tried a bunch of stuff but I'm not getting it. Is there somewhere that I can change this behavior?
  5. J

    Lock Cell formatting (Arial 10) and borders

    Hi Can anyone please assist I am compiling a new template that will be given to our service providers to complete and list their job activities, safety mitigation and so on and so forth. I am 99% done (with a lot of help from some of the guys on this forum) but have one last hurdle I cant...
  6. L

    Automating Text to be formated a certain way.

    Hello. I have a question...if i want to create a custom format where text is center aligned, middle aligned, and applying text wrap when info is created into the cell how do i do that? i'm trying to automate it to do this. Also, how can I automate when info gets inserted into a cell the...
  7. A

    Formatting Macro Does Runs As Absolute

    I am very new to macros. I recorded this macro. I want to be able click on a cell and then have the highlighting go two to the right and then two down, change the border type and color. I think I changed the absolute to relative as that being the right thing to do, but it keeps going back to...
  8. asokaw

    Number formatting issue in Excel

    Hi I need to format a number to show 2 decimals when it has decimal numbers, otherwise not I used #.00 as the format but the problem is when there are no decimals even the .( decimal point ) is shown. how can I not show that decimal point eg. 78 is shown as 78. ( I dont need the decimal...
  9. L

    How do I auto-populate cells based on what is in another cell?

    Hi,This has probably been answered somewhere else but I can't seem to find anything close enough to what I need (and my Excel knowledge is fairly basic)!I have a large spreadsheet that tracks various projects. When a project is complete i change the '% Complete' column to 100% but when I do that...
  10. M

    Number being converted into a date by Excel

    Hello, I have a product number 11-3560 that, when exported into a .csv file from a website, gets automatically converted into a date. When I change the format back to Number, it changes the value to 606609.00 (the numerical date equivalent of the incorrectly used date). Does anyone know how...
  11. C

    Referencing formatted cell in text

    I'm having an issue with a formatted cell. I am trying write som text in a cell and using a cell reference to put a value in the middle of a sentence. It looks like this Cells(122, 1).FormulaR1C1 = "This is text " & Range("B98") & " this is more text." when it returns the cell value I get the...
  12. SimonHughes

    Formatting cells as a prompt

    Hello, I am using Excel 2010 I have a set of seven attributes that need to be selected to chose products from an independent table. I would like to format each step sequentially once the preceding step has been selected. So - when the cursor is is put in the cell that contains "E SONIQ"...
  13. M

    border problem

    i have 2 cells that i cannot change ( add right border ) to the cells. i have tried deleting all border and reapplying. same result. <input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">
  14. K

    Putting values behind drop down menu text

    I have set up drop down menus and are working perfectly, not too complicated i know. but I want to put pricing values behind the drop down menu text. for example, I have a car production pricing spread sheet. I have the available colours in the drop down menu. how can i put different prices...

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