unless you get someone to program it for you.. repost ask for script..
otherwise have simple answers:
- right click cell(s), paste-special values
- all cells start with same / no formatting
- smallest equation / formula for format I have found, for wanting fomatted
cell:
=0=0
=COUNTA(F9)=1


"Tabrez" wrote:

How can colour of cell shading be fixed to one colour and it does not changes
when new contents are pasted in that cell.