I am trying to set up a spreadsheet that will change the cell color if the
formula in the cell has been replaced with a specific value.
Is there any way to conditional format all cells that contain a formula, but
not a constant?

Herb

Hi,

Try this

Go to the Name Manager (Ctrl+F3) and click on New (In Excel 2007). In Excel
2003, Ctrl+F3 would do. In the name box type cellhasformula and in the
Refers to box, type the foll

=get.cell(48,indirect(€œrc€�,false))

Now go to conditional formatting and in Formula is, type =cellhasformula.
Select the desired format

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"hkbarnett" wrote in message
...
I am trying to set up a spreadsheet that will change the cell color if the
formula in the cell has been replaced with a specific value.
Is there any way to conditional format all cells that contain a formula,
but
not a constant?

Herb

See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"hkbarnett" wrote in message
...
I am trying to set up a spreadsheet that will change the cell color if the
formula in the cell has been replaced with a specific value.
Is there any way to conditional format all cells that contain a formula,
but
not a constant?

Herb