formatting cells

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...

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...

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?

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?

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...

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...

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...

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...

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...

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...

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...

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"...

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">

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...