copied fonts are red?

xeven_

xeven_

Active Member
Joined
Jan 20, 2012
Messages
302
I copied a column of data and pasted it in another column, the letters are now red instead of black and it wont let me fix it. Does anyone know what is going on here!?
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
might be a number of things. i thought just doing a ctrl+C ctrl+V would copy and paste the cells formats with the data, but in case it didn't try copy the original column again, right click the destination column with the red text, select paste special, then paste formats and click ok
 
Upvote 0
xeven_ said:
I copied a column of data and pasted it in another column, the letters are now red instead of black and it wont let me fix it. Does anyone know what is going on here!?
Click to expand...

Any conditional formatting on the destination column?
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Conditional Formatting for a Date
Replies
6
Views
292
Joe4
Joe4
D
  • Question Question
Copy specified columns into new sheet
Replies
8
Views
140
MARK858
MARK858
E
  • Solved
Conditional formatting
Replies
8
Views
168
eabaker64
E
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
1K
Micron
M
C
  • Question Question
Exporting columns from Excel Sharepoint to desktop excel
Replies
6
Views
172
course1
C

Forum statistics

Threads
1,224,820
Messages
6,181,154
Members
453,021
Latest member
Justyna P

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