Hi Stefi,
Thanks for ur reply.Could u please tell me how to create macros with
conditional formatting.I tried to create one but i am unable to do it.

Thanks
--
Ruby


"Stefi" wrote:

You might write some simple macros for them assigned to hotkeys!
Stefi


€žRuby€� ezt Ã*rta:


--
Ruby


"Stefi" wrote:

Try PasteSpecial/Values and/or PasteSpecial/Formulae instead of Paste!
Regards,
Stefi

Hi

Thanks for ur reply.If i am handling this worksheet,i can do this,but the
persons who are handling these worksheet is not that familiar in english or
excel.
To avoid them getting confused i am looking for a permanent solution.

€žRuby€� ezt Ã*rta:

I have a problem in the spreadsheet with few many data with conditional
formats.Each cell has different conditional format.When a cell is copied from
one to another the format is getting copied.How to protect the cells without
copying the conditional format?Is there any way to protect only the
conditional formatting of the cell but not the normal formatting?
--
Ruby