See response in worksheet.functions.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ridhi" wrote in message
...
Is it poossible to let the user enter a value in a cell that already
contains
a formula?Like if i am reflecting a value in the Cell A13 from any other
cell
& have used a conditional formating on Cell A13 depending upon the value
that
is been reflecting to Cell A13.Now Cell A13 requies user to enter the
value
to get the calucation done.Entering the value delets the formula in the
Cell
A13 & conditional formating does not work.

Is there any other way to do this ...Please Help