mnm
Posts: 65 
Likes: 16
|
Post by mnm on Nov 8, 2016 21:33:02 GMT
What is the simplest way to get two cells containing the same information in one spreadsheet to automatically highlight themselves.
|
|
registerme
Member of DD Central
Posts: 6,624
Likes: 6,437
|
Post by registerme on Nov 8, 2016 21:49:19 GMT
Conditional formatting?
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Nov 8, 2016 21:59:01 GMT
In Excel, you can try Home -> Conditional Formatting -> Highlight Cell rules -> Duplicate Values
|
|
mnm
Posts: 65
Likes: 16
|
Post by mnm on Nov 11, 2016 9:01:10 GMT
Thanks Neil. Thanks registerme. Thanks for introducing me to conditional formatting. It is very interesting and it does work. The only added thing I found I had to do was click on the top left hand button of the spreadsheet to highlight the hole of the spreadsheet and then use conditional formatting -  image Im using conditional formatting to copy & paste the latest companies listed on the administrators list. Then I copy and paste the portfolio investments. When the duplicate formatting is used it will highlight any compnay in the portfolio with any on the administrator list. I would like to take your advice to further the looking at these company comparisons. In the above example I have deliberately copied & pasted the same 6 companies to show it works. The fourth one IMPRESSION UK LIMITED I have deliberately altered LIMITED to LTD. This can happen when and so copy and pasting and then duplicate formatting will not do what is required. Is there a system that you know of the will continue to Spreadsheeet Snap the 2 lists but is able to allow minor changes like LIMITED to LTD and still highlight the cells? |
|
bigfoot12
Member of DD Central
Posts: 1,817
Likes: 816
|
Post by bigfoot12 on Nov 11, 2016 9:48:21 GMT
You could try a function such as substitute so
in B2:
=SUBSTITUTE(A2," LTD", " LIMITED")
|
|
