• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Ctrl C than auto color cell

A

adeel1

Member
hi every one

need your help that i want when i copy(do ctrl+C) on any cell (cell contain any data) that became with auto any color...

Adeel
 
Adeel

Ctrl+C copies the cell and its contents including background and font color and font style

Its what you do next that is important

If you only want the values goto the destination cell and press Ctrl+Alt+V
 
sorry sir
i do not want this..i just want that when i copy cell its become with color (cell or font any one)

Adeel
 
It does when you use Ctrl+C
that copies everything

Then goto the destination cell and paste what you want
Right click on the destination cell, seelctPaset Special
Then look at each of the available options

If you want to remove the Formatting from the source cell, use Cut (Ctrl+X) instead of Copy
 
sir.may i am unable to explain my problem because English is not a language of us..i try to explain again to you..
there is no color in cell and also no any conditional formatting..i want when i press (ctrl+c) cell change its color its self for my remembering.
 
I don't believe what you want can be achieved

When you select a Cell and go Ctrl+C excel places a colored dashed line around the cell and makes it look like it is moving around the cell

I don't believe there is any way to highlight the cell as you require
 
You must log in or register to reply here.
Back
Top