highlighting formulas vs text?

[Mike]

Hi,

I've got a file to track the progress of our company's continuous
improvement over the year, and I have 4 columns that are initialized in the
file as a formula, when someone sets up the file for the year. As changes
are made over the year, people using the file will start entering in actual
values over top of the formulas, and I was wondering if someone knows of a
non-VBA way (like conditional formatting) that will highlight the cells in
those columns that still have formulas (or highlight the ones that no longer
have formulas) - basically, is there a (non-VBA) .hasformula function?

TIA
Mike
--

____________________________________________________________________________
________________
Please reply to newsgroup so everyone can benefit.
Email address is not valid (see sparkingwire.com)
____________________________________________________________________________
________________

 

[Jason Morin]

There is a non-VBA way that involves cond. formatting and
XLM functions. I've posted an answer to this several times
in the past. Here's the link to one of them:

http://makeashorterlink.com/?E2D032595

HTH
Jason
Atlanta, GA

 

[Mike]

Thank you very much, very handy indeed.

I searched google for this, but "formula" and "conditional" show up quite a
few times, and I gave up, apparently too quickly...

thanks for the quick reply too...