Excel 2007 : conditional format

[allgeef]

Is there a conditional format formula that would format if a cell does not contain a formula? I'm working with Excel 2007. Regards, Gary

[Fotis1991]

Hi

A way to do this,without VBA, is this.

In the link that i send you, there is a way to highlight cells that INCLUDES formula. Use white color for this.

Then highlight you range(manually) with a color that you prefer.

Now all the cells that don't includes formula will stay under your color and cells with formula will be White color..

Is this, helps you?

http://j-walk.com/ss/excel/usertips/tip045.htm