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.

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from the site (each name is actually a hyperlink), the conditional formatting goes away unless I tick the "keep destination formatting", but then the text doesn't have the hyperlink.

I'm aware that you can just keep destination formatting/type the name then add the hyperlink, but this added step takes much more time than simply copying and pasting the hyperlink. Is there a way to solve this problem?

share|improve this question
add comment

1 Answer

Because the hyperlinking format seems to override the 'Applies to' range for the CF there seems no very simple fix. If you are prepared to reset the Applies to range after copying numerous names (ie not 'in real time') that might be easiest. However you could arrange for the conditional formatting to be in a separate column, so the range is not interfered with. Say use Use a formula to determine which cells to format (at the moment I guess you may be applying the option immediately above, ie Format only unique or duplicate values) and in Format values where this formula is true:

=COUNTIF(A:A,A1)>1

assuming your names are in ColumnA starting in Row1.

The Applies to: here would be the reference to the helper column (say =$B:$B).

share|improve this answer
add comment

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.