View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
 
Posts: 109
Default entering value in a cell

Ridhi wrote:
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


I would suggest that you should enter the additional data in another cell NOT
A13, (eg b13) ... use formula in cel A13 to refer to B13

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200804/1