entering value in a cell

[Ridhi]

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

 

[Francois via OfficeKB.com]

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

 

[paul.robinson]

Hi
If a cell contains a formula you don't want to type in it. Otherwise,
why create a formula?
What does reflecting mean? I can't work out what your difficulty is.
You can copy conditional formatting. Create the conditional format in
one cell. Now select that cell and any others you want to format,
click the conditional fomat button again and click OK. Maybe this will
solve your problem.
regards
Paul

 

[Ridhi]

Can you please explain in detail how can we copy conditional formating?

What i am trying to do is

I am creating a excel that will calculate the price of the product.Now if
some one selects "Special" from a drop down list(Conditional formating is
used to change the colour of the cell when "SPecial" is selected) the other
cell colour changes to show that the value has to be entred here.

i tried using lock & unlock cell but that does not work with excel.

Please revert....

 

[paul.robinson]

Hi
That is not a conditional formatting problem. you will need to use a
change event to capture this.

Suppose your dropdown cell that has value Special is in A1 and goes
Yellow when this happens. Suppose the cell with the formula you also
want to go yellow is A4.
Put this macro in the worksheet code module

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A4").Interior.ColorIndex =
Range("A1").Interior.ColorIndex
End Sub

(Open the visual basic editor, double click the sheet name on the left
hand side window and paste in the code).
When you change the value in cell A1 and click off it A4 will go
yellow.

regards
Paul