Mail hyperlink turns white / cant paste directly

I have two cells that wont allow me to paste directly into them /when i post an "mail-hyperlink" into the cell, the text turns white. I have attached the problem sheet, and would be glad for any input that would help me solve this problem.

the cells are formatted to white font ,change it

Hi

I have done both of them no problem the background has been turned red so that you can see it. Dont have much to do with hyperlinks but Im sure I read somewhere that they turn white so cannot be seen try chaning the background colour of your cells on original sheet.


Chris

also there is an option in styles
Click the Home tab and then click Cell Styles in the Styles group.
Right click Hyperlink in the Data and Model field

Click Modify/Format. you can change the font there