is there a way to format all cells that are formulas a color at o.

[Guest]

I have a spreadsheet that has formulas and numbers in it. I want to color
code all of the cells that have formulas but I do not want to have to copy
the action over and over. Is there a way to do the whole spreadsheet at once?

 

[Norman Jones]

Hi Priceie,

Try:

Edit | GoTo | Special | check Formulas | Ok | Apply desired formatting

 

[David McRitchie]

Select all cells with Ctrl+A (unless you have Excel 2003)

Edit, Goto (or Ctrl+G); then Special button, formula with numbers
Then you can format your selection.

You can do this with a macro, in which case these would help
http://www.mvps.org/dmcritchie/excel/proper.htm
http://www.mvps.org/dmcritchie/excel/colors.htm

If you have Excel 2003, use the button at the intersection of
the rows and columns headings -- it is NOT the same but close.
I have a macro on my shortcuts page strictly for Excel 2003
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#CtrlA

You could do this as well with Conditional Formatting but it would
require a User Defined Function, which could slow things down.

 

[David McRitchie]

Basically what Norman said.

If you want more gory details:
Select all cells with Ctrl+A (unless you have Excel 2003)

Edit, Goto (or Ctrl+G); then Special button, formula with numbers
Then you can format your selection.

You can do this with a macro, in which case these would help
http://www.mvps.org/dmcritchie/excel/proper.htm
http://www.mvps.org/dmcritchie/excel/colors.htm

If you have Excel 2003, use the button at the intersection of
the rows and columns headings -- it is NOT the same but close.
I have a macro on my shortcuts page strictly for Excel 2003
http://www.mvps.org/dmcritchie/excel/shortx2k.htm#CtrlA

You could do this as well with Conditional Formatting but it would
require a User Defined Function, which could slow things down.

 

[Gord Dibben]

CRTL + A to select all cells on the worksheet.

F5 Special>Formulas>OK

Format to the color you want.

Gord Dibben Excel MVP