format cells

Hi, I have added a new column as the last column to an existing excel using VBA. After adding a new column, though the background color and other format properties same as that of the adjacent column are applied to the column that I inserted, the grid lines it did not copy the same grid borders...

I am trying to do simple Format of cells to have it display one digit beyond the decimal for numbers that are smaller than 1, and then no decimal for >1. So it should return: 0.2% or 0.5% and 1%, 5%, 10% [>=1]±#%;±0.0%;"" doesn't work. Suggestions?

Occasionally in Excel 2010 when I open Format Cells, I am presented with an odd result. Does anyone have a good explanation? Is my Lenovo keyboard doing this?

I've noticed the fill pattern options within Format Cells is fairly limited. My 2010 Excel version has a total of 18 choices to choose from. I'm curious as to whether there are any available add-ins or custom methods to create your own pattern? I'm in the process of coding a spreadsheet to...

I have created a pricing estimator in Excel. I want to be able to click on an ActiveX command button to generate a new Workbook and name it the client's name in Cell F3. On the same worksheet as the ActiveX command button, I have an estimate. Column A = Quantity Column B = Item Column C =...

So I have a range of cells, specifically A1:LH1100 on Sheet 2. Some of these cells are blank, some contain an ID number. On Sheet 1, I have a dataset which contains ID Numbers in column A, and other descriptive fields in columns B-E I am lookking for a macro that will go through each cell in...

Hi all, Im looking for a row to be formatted in such a way that the height automatically changes depening how much data is in a cell within that row. The cell in question is wrapped and can either have say from nothing to numerous email addresses present. Almost to have the effect of double...

I would like to format my cells so that I can input time between 0 seconds and 1 hour, I would like to format the cell so that it only shows mm.ss All attempt so far to format the cells has resulted in the typed numbers being changed as the format tries to include hours. Is there a way to make...

I'm dealing with a spreadsheet with 134,000+ rows and it's getting very hard to read across w/o jumping from line to line. Is there an easy way to color alternating rows with a different color (similar to an accounting ledger)?:confused:

Hello all, Is there a way to have the format of a cell set to display degrees? I have the formula = A12 in the cell, but I want the number to appear with the degree symbol. Any possible way to do this? Thanks

Hi there!!</SPAN> I created a macro to automatically insert subtotals into a report. Now I want to include code that will format each subtotal row (bold, shaded). My idea is to have the macro search for “ Total” as a String and each time it finds that character string, format the row...

Hello, I have a sheet where values are entered into one cell and if they match a criteria a results cell allows pass or fail. e.g. a value must be between 1-5, if it is within this range, Pass, otherwise Fail. However one cell must match 00000000, the issue is that this changes to just 0 when...

I appreciate any help with the issue am having. here is the what I am trying to do: Column A 35155976 35156348 35156348 35160550 35160550 35160550 35160550 35161189 35161189 35161201 35161201 I would like to highlight the rows (Entire row) for similar values in Column A. so since A2=A3 then i...

I have a code with which I am trying to format Cells A1:I2 on two sheets. I have got the code to add in the formulas and values into the cells, but the code only formats the cells in the first worksheet. Can anyone tell me where I am going wrong? Sub Transfer_Data() 'Add New Workbook...

Hey all, I have number data that is sent to me every week that comes in the General Format which throws off some of my formulas. It's a pain to convert the rows into number format manually every week...is there a macro function that can simplify this task? I tried recording a macro to do it...

Hi, I'm creating sheet that will allow users to paste a list of values. This list has 3 columns and up to 1000 rows that can all be pasted at once. The users will be copying these values from another workbook with various formats. When these values are pasted in I don't want to allow those...

Format number column issue<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I use various mfg part# spread sheets I reconfigure to upload to my website. The columns I basically use are Pt#, description, price. Their sheets are usually sent to me with...

Hello All, I'm working on a function that is supposed to compare text. The way that it works is simple: the function takes in a data range as one of its input variables; the range is set up so that the first column is a custom date format ("mm/dd/yyyy")...in case you didn't notice, that date...

I am writing a VBA to bold and red the text in a cell with the following condition - any words insided "<" and ">" or "{" and "}" (e.g. "xyz <abc> xyz <123>" becomes "xyz <abc> xyz <123>" or "xyz {abc} xyz <123>" becomes "xyz {abc} xyz <123>" the following code is what i try, it work normally...

I'm using VLOOKUP to match across 2 very simple tables of data: First few rows of TABLE 1 are: <TABLE style="WIDTH: 200pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=266><COLGROUP><COL style="WIDTH: 60pt" width=80><COL style="WIDTH: 140pt; mso-width-source...