you can use conditional formatting for this 

--- On Thu, 1/17/13, Manjunath Narayanappa <manjunath.narayana...@aon.co.uk> 
wrote:

From: Manjunath Narayanappa <manjunath.narayana...@aon.co.uk>
Subject: FW: $$Excel-Macros$$ need formula Highlight
To: "'excel-macros@googlegroups.com'" <excel-macros@googlegroups.com>
Date: Thursday, January 17, 2013, 6:41 PM



 






Dear all,
 
Please can I get macro for below requests
 
Regards
Manjunath
 
 


From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Manjunath Narayanappa

Sent: 17 January 2013 08:47

To: 'excel-macros@googlegroups.com'

Subject: $$Excel-Macros$$ need formula Highlight


 

Dear Expert,
 
Good afternoon  have a nice day :)
 
I have a data in the attached spreadsheet, automatically data in B column 
should get highlighted when there is a duplicate or repeated entry.
 
Please help me on this.
 
Thanks
Manjunath

 





PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL







For Aon’s standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp



Aon UK Limited



Registered Office: 8 Devonshire Square, London EC2M 4PL



Registered in London No. 210725 . VAT Registration No. 480 8401 48







Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.
--


Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

 

FORUM RULES

 

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.

--- 

You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.

To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros?hl=en.

 

 






PLEASE CONSIDER THE ENVIRONMENT BEFORE PRINTING THIS E-MAIL







For Aon’s standard conditions associated with this e-mail please visit 
http://www.aon.com/uk/en/email-footer/aon-uk-limited.jsp



Aon UK Limited



Registered Office: 8 Devonshire Square, London EC2M 4PL



Registered in London No. 210725 . VAT Registration No. 480 8401 48







Aon UK Limited is authorised and regulated by the Financial Services Authority 
in respect of insurance mediation activities only.







-- 

Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

 

FORUM RULES

 

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Jobs posting is not allowed.

6) Sharing copyrighted material and their links is not allowed.

 

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.

--- 

You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.

To post to this group, send email to excel-macros@googlegroups.com.

To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Visit this group at http://groups.google.com/group/excel-macros?hl=en.

 

 

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.


Reply via email to