Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

When using LibreOffice on a mac, I can only set the cell font style of a hyperlink that has been visited (opened in a browser). I cannot set the font style of a cell that has an 'unvisited' hyperlink.

How can I do this?

share|improve this question

1 Answer 1

There are different options, depending on your needs. You could use a custom cell style only for cells containing hyperlinks, but you will have to assign that style manually or using a macro.

Another way would be to use Conditional Formatting. With conditional formatting, you could check either for the cell text starting with "http", for example (using the LEFT function). But this works only if you're using the URL as link text.

Another approach would be to insert hyperlinks using the HYPERLINK function. This way, you could use conditional formatting again, checking if the current cell contains the HYPERLINK function with the help of the FORMULA function.

All those approaches aren't really straightforward, but they may work as a workaround.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.