Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can colour of cell shading be fixed to one colour
How can colour of cell shading be fixed to one colour and it does not changes
when new contents are pasted in that cell. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can colour of cell shading be fixed to one colour
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can colour of cell shading be fixed to one colour
You could use this event code to retain the Formatting of the target cells.
Note: does not work if cells are CUT and pasted Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue .EnableEvents = True End With End Sub Right-click on the sheet tab and "View Code". Copy/paste the code into that sheet module. Alt + q to return to the Excel window. Gord Dibben MS Excel MVP On Tue, 23 Sep 2008 03:00:01 -0700, 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to add cells based on their shading / fill colour? | Excel Discussion (Misc queries) | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
How do I customise the colour of cell shading? Thank you | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |