Hi Pavan Try this Code, See the attached File
Sub HighLight()
Dim intI As Integer
For intI = 1 To Range("rngMyRange").CurrentRegion.Rows.Count Step 2
If Left(Cells(intI, 1), 3) <> Left(Cells(intI + 1, 1), 3) Then
Cells(intI, 1).Characters(1, 3).Font.ColorIndex = 5
Cells(intI + 1, 1).Characters(1, 3).Font.ColorIndex = 5
End If
If Right(Cells(intI, 1), 3) <> Right(Cells(intI + 1, 1), 3) Then
Cells(intI, 1).Characters(4, 3).Font.ColorIndex = 5
Cells(intI + 1, 1).Characters(4, 3).Font.ColorIndex = 5
End If
Next
End Sub
-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pavan Kumar
Sent: Apr/Thu/2012 07:21
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Highlight the Words
HI,
Yes, it's more than one and it's not on formula they are text and i will be
using this macro with the file structure macro which will provide me the
file names and folder names and i will be comparing this data with old data.
Regards,
pavan Kumar G
On 4/26/12, dguillett1 <dguille...@gmail.com> wrote:
> More info:
> more than one?
> show layout example
> are they text or formulas
> etc.
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -----Original Message-----
> From: pavan Kumar
> Sent: Thursday, April 26, 2012 4:34 AM
> To: excel-macros
> Subject: $$Excel-Macros$$ Highlight the Words
>
> Hi Team,
>
> I am looking for a macro to highlight the difference word
>
> Example: Comparing two cells
>
> ABCFeb ABCMar
>
> Then Only Feb and Mar should be highlighted.
>
>
> Regards,
> Pavan Kumar G
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
> ----------------------------------------------------------------------
> -------------------------------- To post to this group, send email to
> excel-macros@googlegroups.com
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 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) Cross-promotion of, or links to, forums competitive to this forum
> in signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum owners and members are not responsible for any loss.
>
> ----------------------------------------------------------------------
> -------------------------------- To post to this group, send email to
> excel-macros@googlegroups.com
>
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
----------------------------------------------------------------------------
--------------------------
To post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
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) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
Hightlight.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
