Conditional format to highlight only cells with formula, not const

H

hkbarnett

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
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top