In addition to the below the cursor (Activecell) should be in B2 cell.
---
Ms.Exl.Learner
---
On 12/23/10, siti Vi wrote:
> select the range of your Numbers
> for example: B2:B200
> you can apply a conditional formatting on that range
>
> the condition FOR
select the range of your Numbers
for example: B2:B200
you can apply a conditional formatting on that range
the condition FORMULA is
=COUNTIF($B$2:$B$200;B2)>1
On Thu, Dec 23, 2010 at 2:04 AM, Superkermit wrote:
> I have a excel spreadsheet that has model numbers on the start of a
> column a
I have a excel spreadsheet that has model numbers on the start of a
column and then a space and a description, what I need to do is be
able to have excel find all the duplicate model numbers and highlight
them, how should I go about doing this?
--
-
