Conditional Formatting can affect the colour and font effects in a
cell, but it can't do what you describe. I think you would need some
VBA to do that - perhaps, you change the background colour of the cells
you want it to apply to (eg to yellow) then invoke the macro. This
would look for yellow-coloured cells and display the formula in there
if there is one. You'll also need to undo the effect, so perhaps it
would be better if it toggled the display each time you ran it.

Hope this helps.

Pete

MrsWiz wrote:
Barb thanks.
This looks like Macro add-ins the FORMULATEXT function resulting in the
display of the formulae in a cell within another cell that is possibly off
the sheet or the like.

I'm after being able, instead of the Tools\Option\View_Formulas function
which shows a whole sheet's formulae, to change a cell or two to show their
formulae whilst leaving the rest of the cells in the same sheet that contain
formulae displaying resulting values.
I'm thinking that Conditional Formatting using the Formula IF statement
telling the cell what to display if it contains 'such and such a formula'
then 'display this formula' is perhaps the way to go? This would mean
formatting each applicable cell with the IF statement display and it could
not be applied by highlighting the first cell and dragging/ copying to
others.
Suggestions please.



"Barb Reinhardt" wrote:

You could use the FORMULATEXT function in the MOREFUNC addin found here

http://xcell05.free.fr/english/index...func_Functions

"MrsWiz" wrote:

Want to be able to see and print just one, or a few, cells showing their
formulae; not have to have the whole sheet displaying their formulae.