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