Excel 2003 Question

[ksherman]

Hey all.

I work a lot in Excel, but have never had any training or taken any classes, so I don't know all the ins and outs of the different options I have and so I take this question to the community. 🙂

Essentially, I am making machining for cabinets to be run on a machine to receive holes and cut-outs etc. all based in an Excel spreadsheet. So within these templates, I have many, many formulas. As I am sure many of you know, if you don't copy or move things exactly right, you loose the formatting and instead only get the results copied to another cell. This spells death for my templates.

Now, I am careful and check my formulas as I go, but others are not so careful.

Is there a way that any cell that has (or doesn't have, which ever is easier) a formula to recieve special formatting, say the font becomes bold or the cell changes color? This would go MILES towards allowing me to be able to ensure my fomulas are actually formulas without checking each of the hundreds of cells that contain a formula. Is this something that Excel 2007 might be able to do better?

Thanks for any help you might be able to offer!

- KS

 

[mayest]

I'm not sure that I understand what you are asking. It seems that you want to apply Conditional Formatting to cells that have formulas. I don't think you can do that directly, but you can use the following VBA function as the formula in conditional formatting:

Function IsFormula(ref As Range) As Boolean
IsFormula = ref.HasFormula
End Function

In the conditional formatting dialog, select your range of cells and then just specify a formula as:

=IsFormula(A1)

Finally, apply whatever conditional format you want to see if a cell has a formula.

 

[PowerEngineer]

Another option you might find useful is go to Tools>Options. On the View tab under Windows options, check the Formulas box. You'll be able to see the actual formulas in each cell.