try this :
http://zo-d.com/blog/archives/programming/changing-cell-background-color-in-microsoft-project.html
When you change the color of the fill in a cell you are changing its format. This action applies to Microsoft Excel.
Right-click on the cell or range of cells you want to change and click on cell format. From the cell format window, select a number format of currency.
Yes, the Cell Styles menu on the Insert tab is used to quickly format a cell by choosing from predefined styles. Microsoft Excel is part of the Microsoft Office suite.Ê
Format the cell as text. You also can input a formula: =text(A1) Remark: if the content is in cell A1.
Select the Cell and press Control + 1 or find format cell. Select the option under the "Number" tab "Text"
any color u want
Cell formatting in Excel allows you to define how the cell contents should appear. Some examples of formatting are bold, italics, character color, cell background color, currency, time, etc.
You do not format a column, you format a cell. If course, you can format all cells in the column to accomplish what you are asking. To format an entire column, click on the letter at the top of the column, then select cell format and make your selections. Since there are hundreds of ways to format a cell, I will not list them all here. Some of the ways to format cells are: by color (cell background and font), by font attribute (bold, face, size, etc.), cell border (multiple assortment of lines and colors), by number attribute (time, percent, currency, etc.), and many more.
To format a cell in excel right click on it, then on the thing that pops up click on format cell
-put on cell1 the numerator -put on cell2 the denominator -solve(cell1/cell2) -right click on cell3(it is where the answer is located)-format cell-fraction-okay -to make the fraction in lowest term, format-cell-number-custom-then type #
You can use the text formatting options like bold, italics, underline, font color, and alignment in word processing software such as Microsoft Word to format text. For graphics, tools like resizing, cropping, rotating, and applying filters can be used in graphic design software like Adobe Photoshop.
If you do not like how the dates are formatted, then change the date format of the cell to whatever style you would like to display.