How To Change The Cell Outline Weight In Excel For Mac

Convert a data table (Excel table) to a normal cell range in Excel. There are two necessary steps for changing your table to a normal range (the numbers are corresponding to the picture): Click on a cell within the Data Table. On the Border tab, under Color, click the color that you want to apply, and then under Border, click the specific pieces of the cell border to apply the color to. Tip: To apply your new cell style, select the cells that you want to change, and then on the Home tab, under Format, click the style.

You can only do it with VBA! Mac calendar app for spark. You cannot do it with formulas in one cell with Custom Formatting or cell formulas: But, If all your data is in grams for amounts less than 1000 and any data entered greater than 1000 is KG, so 999 is 999g but: 1001 is enterd in KG not grams so you can never enter something like 1.1KG then this Custom Format will work: [>=1000]#,##0.00'kg';0.00'g' Note this does not convert grams to kilograms only determins if 'g' or 'kg' should be used!

The best solution would be for a Change Event Macro, but we need your Range or Column that contains this data and if it is continuous or not!