Dilip, thank you. However, this method requires me to have 1
additional column => if the user decides to add another column just
like B, then he/she will have to copy that "supporting" column A. This
adds mess to the spreadsheet.
Thanks!
On Oct 16, 3:31 am, Dilip Pandey wrote:
> Hi Mark,
>
> As
;
> Excel 2003. I go to add a module, copy&paste your code and then excute
> the macro.
>
> BTW, I wish this was code as a function.
>
> On Oct 15, 1:39 pm, Paul Schreiner wrote:
>
>
>
> > what version of excel are you using?
> > WHERE are you getting the run-ti
wrote:
> what version of excel are you using?
> WHERE are you getting the run-time error?
>
> Paul
>
>
> From: Mark Livingstone
> To: MS EXCEL AND VBA MACROS
> Sent: Thursday, October 15, 2009 11:18:07 AM
> Subject: $$Excel-Macros$$ Re:
Hi Mark,
As you have the query to just highlight the cells in column B, which are
there in Column E, so I hv done accordingly. Now if you want to count the
matching entries as well, please look at the attached file which I have
enhanced as per this new requirement.
Best Regards,
--
DILIP KUMAR
?
>
> Paul
>
>
> From: Mark Livingstone
> To: MS EXCEL AND VBA MACROS
> Sent: Thursday, October 15, 2009 11:18:07 AM
> Subject: $$Excel-Macros$$ Re: How to match numbers from 2 columns with
> minimal formulas
>
> Paul, thank you. Unfortunately this code doesn't
what version of excel are you using?
WHERE are you getting the run-time error?
Paul
From: Mark Livingstone
To: MS EXCEL AND VBA MACROS
Sent: Thursday, October 15, 2009 11:18:07 AM
Subject: $$Excel-Macros$$ Re: How to match numbers from 2 columns with minimal
Paul, thank you. Unfortunately this code doesn't work. I get run-time
error 438.
On Oct 15, 9:05 am, Paul Schreiner wrote:
> you sure don't give much to go on...
> what do you mean by "highlight"?
>
> there are lots of ways to do what you're asking.
> here's one I threw together.
> it "highligh
Dilip, thank you! Works great but since it is conditional formatting
that uses "formula is", I can't count the # of colored cells.
http://www.cpearson.com/excel/CFColors.htm << his code doesn't work
with the "formula is" statement.
On Oct 15, 9:23 am, Dilip Pandey wrote:
> Hi Mark,
>
> I have g
Hi Mark,
I have given a try on this and attached a workbook with the scenario along
with the desired results. I have used conditional formatting logic to
achieve the task.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.
you sure don't give much to go on...
what do you mean by "highlight"?
there are lots of ways to do what you're asking.
here's one I threw together.
it "highlights" by changing the font to bold and red:
Option Explicit
Sub IsPresent()
Dim bRow, cRow
'Reset previous "highlights"
Range("
10 matches
Mail list logo
