Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do i make everything pasted into a column always the same colour?

I want to be able to drag and drop any text into a column and have it automatically take on the particular colour (indeed any formatting) that I assign to that column.

(Right now it just keeps it's original formatting).

I know I can use 'paste special' but I will be doing alot of text moving, so I prefer to be able to do it with simple drag and drop - or any typing I do in that column.

It seems like conditional formatting may be able to do it but there doesn't seem to be an easy way to indicate "any text".