Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
entering value in a cell
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
entering value in a cell
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 On Apr 24, 8:15*am, 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
entering value in a cell
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.... " wrote: 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 On Apr 24, 8:15 am, 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
entering value in a cell
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 On Apr 24, 9:19*am, Ridhi wrote: 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.... " wrote: 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 On Apr 24, 8:15 am, 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- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get the tab key to go to the next cell after entering | Excel Discussion (Misc queries) | |||
Entering digits in a cell with numbers already inside cell | Excel Worksheet Functions | |||
after entering a text in one cell, next cell should disp the entd | Excel Discussion (Misc queries) | |||
How do you do hard returns in 1 cell? entering address in 1 cell | Excel Discussion (Misc queries) | |||
automatically date a cell when entering data in adjoining cell | Excel Programming |