Copy interior color of cell

K

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,664
I have some cells that change colors based on output.

The paste and paste special functions don't always copy the correct color of the cell.

Has anyone run across this before and what is the correct code to do this?

Kurt
 
Sort by date Sort by votes
Hello Tom,

Yes exactly, the color format means very specific things to the users, but the conditional format expressions do not need to be saved on the reports sheet.

Again many thanks for your time and efforts!

Kurt
 
Upvote 0

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
I don't want to reinvent the wheel as I imagine that someone has probably written some that does this. I'll post and see.
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Chase cell color for every other variable
2
Replies
13
Views
624
Joe4
Joe4
J
  • Question
INDEX MATCH from two sheets onto third sheet?
Replies
1
Views
163
etaf
etaf
C
  • Question
Loop validation, copy output from same range and paste in different ranges
Replies
1
Views
449
RoryA
RoryA
N
  • Question
My code is suddenly really slow
Replies
1
Views
170
RobP
R
C
  • Question
Calculations require application restart
Replies
2
Views
220
cpupartsplz
C

Forum statistics

Threads
1,215,986
Messages
6,128,115
Members
449,423
Latest member
Mike_AL

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top