Conditional Formatting - Change font colour based on whether cell contains formula or not

[milkychips]

I was wondering if this is possible?
I have a bunch of cells (say A1:A10) that each contain a formula suggesting a value, assume A1 has the formula =B1+C1, copied down.
If I then edit A1 manually by typing in a number, I would like the A1 cell to display a different colour (so that I know that I have edited it and there is no longer a formula within it)

Any suggestions as to how I can do this?

[berlan]

Hi,
One way is to use the old XLM through a defined name to see if a cell has a formula.

Start by defining the name IsFormula (under Formulas->Name Manager) as:

Please Login or Register  to view this content.

Then set the conditoinal formatting through a formula ("Use a formula to determine which cells to format") on the cells you want to format and apply the color settings you want. The conditional formula for non-formulas should equal:

Please Login or Register  to view this content.

More reading about the XLM in this instance can be found at http://www.mrexcel.com/forum/excel-q...arguments.html

Hope that helps.

Rgs,
berlan

[milkychips]

Works a treat.
Thanks Very Much