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.
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.
Last edited by tis1337; 11-21-2012 at 01:03 PM.
the cells are formatted to white font ,change it
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
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
Click my star if I helped Thanks
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
The hyperlink modify in cell styles worked. Thx alot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks