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 |
Entering value in a cell
You can't have a formula and a value. You could add event code (VBA) to
simulate CF, but once gone, the formula is gone. -- --- 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 |
Entering value in a cell
Thanks
"Bob Phillips" wrote: You can't have a formula and a value. You could add event code (VBA) to simulate CF, but once gone, the formula is gone. -- --- 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 |
All times are GMT +1. The time now is 08:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com