highlighting formulas vs text?

  • Thread starter Thread starter Mike
  • Start date Start date
M

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)
____________________________________________________________________________
________________
 
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...
 
Back
Top