style

I have been trying to concatenate cells from a different master sheet into one cell for a label. the problem is that some parts of the text are bold (for allergens) and when I finish it erases all the formatting from original cell. I've tried several different macros and nothing works. Please...

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

If I create a new style in Excel, what is the best way to ensure that style formatting applies ALL of the time. Before being aware of styles, I would select all cells and change colour or font, but during insertion of rows/columns, often the formatting would revert back to the "Normal" style. Is...

I'm trying to create a macro that does the following: On theButton was clicked set theButton style =msoShapeStylePreset12 Run the query Query refresh completes set theButton style = msoShapeStylePreset14 end But, the button doesn't change until after the query has refreshed. I eve...

Hello, I am trying to find each location where a style is used and SELECTIVELY replace that style (one by one, manually) with another style. I am not trying to replace all usages of one style with another style, blindly. Is that possible? Many thanks. Keith

Hello All This should be easy but I can't get it to work. I made and style in a workbook called Full Date Time. I want to have this be available in all Excel sheets I open from now on. I saved this workbook as a template file, called it Book.xltx and put it in the XLSTART file but it...

Wouldn't it be advisable to avoid using a lower case "L" for, say, a loop when it (l) looks too much like the number 1?

Hey pro-team! Our company has a problem with copying and pasting data dumps from our ERP system into workbooks over-and-over, resulting in compounding workbook styles to the point where multiple workbooks each month hit the excel style count max (~64,000), which causes workbook crashing and an...

Good day All, Hope all is well. Could you please help me on how I can change the pivot table style being generated by the below macro. Currently, it generates "Classic" view, and would like to change it 'Table Style Light 20'. Sub CreatePivot() ActiveWorkbook.Sheets("Pending...

Howdy, I am an expert in a lot of things Excel, and this is driving me nuts! I create a chart and format it the way that I want. However, when I add a slicer, it changes the chart to a built-in style. I even save the chart as a template but that doesn't work. Is there a way around this...

I have a medical vision issue because of which I am able to only use a dark background. Sometimes I get Microsoft Excel workbooks which are designed to be viewed on a light background. In those cases, I have to change the colours usually using the table style feature available in Microsoft...

Hi, What formula would be best for a "3D" style SUMIF, to allow a matrix of values to be summed, as in the example below (sorry I can't get the image function to work, so it's a link instead). https://imgur.com/13Pda1w James.

I am working with just 2 columns. I am writing a macro to get the value from column A and put it in column B, overwriting the tag style, so that row 1 appears like the following: The Regency Straight Back is a traditional ....., and do this for all rows Column A...

I have been trying to build out a spreadsheet that will digest key data from a sales report then generate a form that will identify wins and opportunities for each sales consultant individually. I have been able to sort them using splicers but it doesn't look this good. How do I apply a style...

Hey all, new here and excited to ask questions and learn. I was searching the net and all and couldn't find any specific answer to the question as the title implies. So far I was able to learn, that if you want scrollable text in specific cell, I need to use under the Active-X section, choose...

I'm trying to change the font color in Normal style. I have been able to change the default font and default size but not the default color.

I'm using Excel 2007 Hi All, I want to use VBA to check if a Pivot Table Field is bold. This is the code I am using: For iLoop = BottomOfPage To TopOfPage Step -1 For Delay = 0 To 20000000 Next Delay CellSelect = "A" & iLoop MsgBox CellSelect Range(CellSelect).Select...

Hey all, A little background on my vba project: When the date in a cell is a past date, the cell style changes to "Bad". I am trying to code this logic: If you change a past date to today's or a future date, then change a cell in another column, but same row, to the style "Neutral". For some...

I have a worksheet that has a large amount of cells using a custom cell style to apply a number format that I change through VBA. I would also like the cell style to include the "shrink to fit" option. When I modify the cell style to include "Alignment:Shrink To Fit", nothing happens in the...

Dear all, My boss asked me if it is possible to insert PDF style digital signatures into an Excel file. She wanted each of those to represent "approval" of a request, for example: expense reimbursement, etc. A PDF style digital signature takes the place of a person's personal signature. I...