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

P

priceie

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?
 
N

Norman Jones

Hi Priceie,

Try:

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

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

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

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
 
Top