text vs picture of text

butch

New Member
Joined
Apr 8, 2002
Messages
3
i need excel to color a cell when i type in a specific character (in this
case the letter 'W' is conditioned to shade the cell 'green'. This is used
for graded wins(W) and losses (L) in baseball) with the "L" losses to be
colored in blue.

i have done that, under conditional formatting. But when i copy and paste
the same 'logs' from a website and paste them into Excel (to save time for
adding many games to the logs instead of typing each result of "W" and "L ")
for the shading to take place , of course the entry is not text but a
picture of text ( a bitmap .bmp i guess) and Excel will not shade (or
pattern ) the cell
How (or can) i paste the results from a webpage and have Excel format the
characters as if i were typing in text from the keyboard?
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
my box had choices of
paste as html
paste as unicode text
paste as text with no formatting
i had no luck there
 
Upvote 0
ok. try pasting as text in other cells.
then copy and paste it as special--text only. int he correct cells

see if that works.
 
Upvote 0
i can tell you have me on the right track......i need to tinker a bit moreto get the results i need
thanks alot ...3 other boards got blank stares at this question for days
CHEERS
 
Upvote 0
Butch,

when I copy from this board (ie formulae) I use paste special unicode text...... otherwise, as you say, it comes with the colours and formatting
 
Upvote 0
Hi

Sorry guys think this

copy... ermm what exactly are you copying.. text values or something else..

so then your pasting what you copy....

so maybe you copying more than you think...poss you taking something with you??? Yes ... No???

dhtml or pearl whatever Bill runs this board on is not just text so all carries over.. format intacted... so i beleive.
 
Upvote 0
When you copy from many Windows programs (especially Microsoft apps) the clipboard maintains details about the type of document you copied from, and then attempts to replicate that when you paste to an app that'll support it (like Excel, Word, or Outlook).

To get around this, try Paste Special, then use either Text or Unicode. Text works great for me, but would possibly hose up what you're copying if it includes extended characters (character values > 128).
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,972
Members
448,537
Latest member
Et_Cetera

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