Negative Percents Not In Red

T

Tom R

I am having trouble getting a negative percent to show in red. It is a
reference from another cell, and doesn't seem to work. Any ideas?
I have the cell formatting to show and when I type in a negative percent it
shows correctly. But when I reference another cell to get the data it
displays in black

any thoughts appriciated
tom
 
E

Earl Kiosterud

Tom,

Try a custom number format code (Format - Cells - Number - Custom) like:

0%;[Red]0%
0.0%;[Red]0.0%
 
T

Tom R

Thanks for the info. I applied the formatting to the source and it did not
take there either. So the problem is in the source data. It is data brought
over from Access, and it seems the only way I can get formatting to take it
to clear the contents of the cell and reinput the data. Only then will the
correct RED formatting hold.

Thanks again for the help

tom
 
F

Frank Kabel

Hi
see your other post. Try using the following on your soruce data:
- copy an empty cell
- select your imported data
-. goto 'Edit - Paste Special' and choose 'Add'
 
Top