• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can i use conditional format on this?

A

ananthram

New Member
now i have some data and some ID's but i need to check the ID's which are duplicates and i use the below formula to find duplicates i.e. more than one ID it shows the value if true/false and this i will be updated the ID's regularly and i autofill the data regularly. So please help me how to use the same formula on conditional formatting if possible. please find me a solution or post step by step guide


thanks in advance.


=IF(COUNTIF($A$2:A2,A2)>1,"duplicate","Not a Duplicate")
 
Hi Ananthram,


Try this,


Press Alt+HLN keys then select use formula to formate and put the below formula:


=COUNTIF(A:A,A1)>1 and then select color to highlight the cells.


This will highlight the duplicate values in column A.


P.S. I have done this in office 2007


Thanks & Regards,

Anupam Tiwari
 
Hi Ananthram..


In addition to Anupam.. if you want only to highlight the second + item's (as per your provided formula), not the first Item..

just change a little.. :)


Code: 
=COUNTIF($A$1:$A1,$A1) > 1


@Anupam..

OOH.. you have office > 2003.. ;)
 
Hi Deb,


I have both 2003 and 2007 however that filter part being not used, missed out how to use.


By the way thanks for your help.


Regards,

Anupam Tiwari
 
Thank you friends for your quick response. But what i meant is i will be keep on updating data day by day and in that data i need only duplicates to be highlighted not the other's so both the formulas dint work properly please suggest me if there is another formula's
 
Hi ananthram,

In addition to Anupam.. if you want only to highlight the second + item's (as per your provided formula), not the first Item..

just change a little.. :)


=COUNTIF($A$1:$A1,$A1) > 1
Click to expand...
 
@Debraj Sorry but u have posted the same. Ok here is quick reference


1. I used to update the tracker regularly.

2. When i update and if i get a value "duplicate" and not the "not a duplicate" then only "duplicate" value which i have updated should highlight not the other one.

3. I have already 13k of this data which already updated. So i should count on all of them.


please please please suggest me some idea on conditional formatting.
 
Hi, ananthram!


Consider uploading a sample file (including manual examples of desired output), it'd be very useful for those who read this and might be able to help you. Thank you.


Give a look at the second green sticky post at this forums main page for uploading guidelines.


Regards!
 
@SirJB7 Please look to the below link and please check with the past comments i need help on conditional formatting


https://docs.google.com/file/d/0B9Hkz2Emr9enWW9tU3BHejd6aVE/edit
 
Hi, ananthram!

You should grant access to your uploaded file, otherwise it'd be unavailable.

Regards!
 
Hi, ananthram!

Sorry but I don't use Google Docs, so I don't know how. I just sent you a request from a link that was below the error message. Perhaps that helps you.

Regards!


EDIT: got access now.
 
Hi, ananthram!

Give a look at this file:

https://dl.dropbox.com/u/60558749/Can%20i%20use%20conditional%20format%20on%20this_%20-%20Book1%20%28for%20ananthram%20at%20chandoo.org%29.xlsx

It operates on columns A:C checking for column B values when repeated and non-blank.

Regards!
 
Sir Mind Blowing Superb thanks a lot Huuuhahaa!!~ sir please give me ur skype or and gtalk ID so that i can chat with u for more information...
 
Hi, ananthram!

Glad you solved it. Thanks for your feedback and for your kind words too. And welcome back whenever needed or wanted.

Regarding mail or msn or skype addresses I have some personal thoughts that might be reflected in this link:

http://chandoo.org/forums/topic/locking-the-cell-automaticall-once-the-date-passed#post-21903

Regards!
 
You must log in or register to reply here.
Back
Top