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?
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?