autofill cell with color after ctrl C (copy)

[adeel1]

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

[adeel1]

anyone can help.??

[FDibbins]

Why not just use the Format Painter?

[adeel1]

actually we have sheets that from where we copy data and paste in our portal and data in horizontally many time speed work made lot of mistakes, our worker miss copy cells,unable to manage the sequence, if we use format painter this take lot of time that first we copy data than paste in portal than make color of it...if you can do the needful

[adeel1]

any solution sir.???

[FDibbins]

Sorry, I could not understand most of what you said there

I dont see how using ctrl click to pick up a cell's formatting, then clicking in another cell to transfer that, is any quicker/easier than clicking on the format painter, then clicking on another cell?

If you dbl click the painter, it stays effective until you click it again, or press escape, so you can apply that same formatting to many cells just by clicking on them

[adeel1]

sorry sir may i am unable to explain my problem..i try to explain to you it again that one of my friend have VBA like when he hit enter the color of cell has change its self and similarly i want that when i use ctrl C (not pasting that data in any excel sheet or workbook just did crtl C) cell color change its self for our remembering or any VBA like that which of cell use as ctrl C fill with colors..

[Cdubisms]

I'm confused as well. If you're not pasting it, I'm confused as to why you're copying it. Also, if you're just putting it on your clipboard (when you use CTRL + C), you're not changing the cell you're copying at all, so why would you want the color to change just because you copied it?

[adeel1]

dear Cdubisms
may you are right we paste this data to portal (software) to perform dffirent activities actually we have sheets that from where we copy data and paste in our portal and data in horizontally many time speed work made lot of mistakes, our worker miss copy cells,unable to manage the sequence, if we use format painter this take lot of time that first we copy data than paste in portal than make color of it...if you can do the needful

[adeel1]

More explantion that data exist in for example A7 to F7..sequencely need to copy data for pasting in portal that a7,b7,c7 respectively..some time wrongly we copied c6 instead of c7 beacuse there is no clue after pasting data in portal than in excel for rememering that why we need to highlight the cell auto with crtl c...if anyone can provide the solution with great mind and experience ...

[adeel1]

is this possible..??