highlight cell with macro

[max_max]

Hello,
are max_max and Italian, and I hope that my English is understandable.
I am looking for a macro that does this:
I have some columns C - F - I - L - O
the macro I should highlight in yellow the cells in which there are repeated values
the macro must also highlight the cell to the right of the found
Thank you,
max_max

[extremis]

You dont need macro for that

1:Select the entire columns C - F - I - L - O.

2: Go into Home

3: Select Conditional formatting in the style tab.

4: Select hightlights cell rules, then equal to...

[FDibbins]

@ extremis I would caution against using entire columns (or rows) with Conditional Formatting. It can become very resource-intensive and slow files down. Rather, confine the range to the largest that you think you will need - you can always increase it later if needed.

Also, the rule to use for this is "Format Only Unique or Duplicate Values"

[max_max]

hello extremis,
thanks for the reply but personal needs I use a macro

[max_max]

My problem is this:

Please Login or Register  to view this content.

max_max

[extremis]

Please Login or Register  to view this content.

Just change the number 2 for the number that will duplicate...

[extremis]

Please Login or Register  to view this content.

try this one..

FDibins..thanks, i am currently learning right now and I am trying to learn how to write my own macro

[max_max]

Thanks extremis,
but to highlight the value is not only one but can more than one and different
The macro should start automatically when you start Excel
max_max

[FDibbins]

Will the duplicated values be across the row, or down the column?

[max_max]

Hello,
I hope to explain I'm translating from Italian into English with google translator.
Duplicate values ​​are in columns I've posted before
max_max

[max_max]

Buongiorno a tutti.
In Italia sono le 15,00 ( 3 p.m.)

Good morning everyone.
In Italy are 15.00 (3 p.m.)

max_max

[max_max]

Ciao a tutti,
posto un esempio per capire cosa cerco.
Cosa cerco è scritto nel file.
Un grazie a tutti

Hello to all,
place an example to understand what I'm trying.
What I seek is written to the file.
Thanks to all

example1.xlsx

max_max

[jindon]

Try this

Please Login or Register  to view this content.

[max_max]

hello Jindon
I get the macro
max_max

[max_max]

Hello,
jindon you're awesome!
I tried the macro and it works.
THREE correction of equipment:

the macro must always be active must not start with run / macro

when I delete a value cells must not remain highlighted.

after the cancellation of the values ​​in columns C / G / I / L / O is highlighted next column D / H / J / M / p

I hope I explained.
thanks,
max_max

[jindon]

Add the code to the sheet module

Please Login or Register  to view this content.

[max_max]

Hello jindon,
I do not see your new reply, because of the backup of the forum?
max_max

[max_max]

hello jindon,
I now see the new macro and it works fine.
One problem remains highlighted cells in columns D / G / J / M / P after the delete as an example:
print_screen 1.jpg
max_max

[max_max]

hello jindon,
I now see the new macro and it works fine.
One problem remains highlighted cells in columns D / G / J / M / P after the delete as an example:
max_max

[jindon]

Change to

Please Login or Register  to view this content.

[max_max]

I do not see the second page of the thread!

[john456852]

you should change ".value=empty" with ".delete"

[max_max]

Non vedo la seconda pagina del thread!
Mi tocca inserire una nuova risposta.

I do not see the second page of the thread!
I need you to reply

max_max

[max_max]

Hello jindon
the macro works, thank you!
I made a change to the sheet and I added
values ​​in the range A2: O2 and in the range A35: Q35 and I showed these ranges,
should not do it.
print_screen 2.jpg
max_max

[jindon]

..................

Change to

Please Login or Register  to view this content.

[max_max]

Hello jindon,
the macro works, thank you!
I made a change to the sheet and added values
in the range A2:O2 and in the range A35:Q35.
The macro will highlight these ranges,
should not do it.
print_screen 2.jpg

Ciao jindon,
la macro funziona, grazie!
Ho fatto una modifica al foglio e ho aggiunto dei valori
nel range A2:O2 e nel range A35:Q35.
La macro evidenza questi range, non deve farlo.

max_max

[jindon]

Post your workbook instead of picture.

Picture doesn't help at all.

[max_max]

Hello jindon,
here's the file.

Ciao jindon,
ecco qui il file.


example 02_07_13.xlsm


max_max

[jindon]

Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[max_max]

You are a magician!
You can remove flicker (not sure if it translates into English exactly) when you insert a new value?
I tried with:
Application.ScreenUpdating = False
Application.ScreenUpdating = True

Please Login or Register  to view this content.

but does not change.
Thanks again.
max_max

[max_max]

Ciao a tutti gli amici del forum dall'Italia
Hello to all friends of the forum from Italy

max_max

[max_max]

Hello jindon,
I made a change to the workbook.
I added a new sheet and now sheet 1/2 are connected.
If I write a 2 identical numbers in sheet2 the macro test fails.
Why macro test functions, I have to do macro - run.
max_max

Ciao jindon,
ho fatto una modifica al foglio.
Ho aggiunto un nuovo foglio e ora foglio 1 /2 sono collegati.
Se scrivo un 2 numeri uguali nel foglio2 la macro test non va.
Perchè la macro test funzioni devo farlo da macro - esegui.
max_max

example_07_07_13.xlsm

[max_max]

Hello jindon,
I made a change to the workbook.
I added a new sheet and now sheet 1/2 are connected.
If I write a 2 identical numbers in sheet2 the macro test fails.
Why macro test functions, I have to do macro - run.
max_max

Ciao jindon,
ho fatto una modifica al foglio.
Ho aggiunto un nuovo foglio e ora foglio 1 /2 sono collegati.
Se scrivo un 2 numeri uguali nel foglio2 la macro test non va.
Perchè la macro test funzioni devo farlo da macro - esegui.
max_max

Attachment 248466

[jindon]

Delete Worksheet_Change event code and replace with

Please Login or Register  to view this content.

[max_max]

Jindon you are magnificent, now it works fine!
Thank you.
max_max

Jindon sei magnifico, ora funziona bene!
Grazie.
max_max

[max_max]

I made ​​another change to the workbook.
Now I added a conditional formatting to find equal numbers compared to cell G37,
it is possible that this research a macro to do it?
Hello and thank you.
max-max

Ho fatto un'altra modifica al workbook.
Ora ho aggiunto una formattazione condizionale per trovare i numeri uguali rispetto alla cella G37,
è possibile che questa ricerca lo faccia una macro?
Ciao e grazie.
max-max

example_07_07_13_2_B.xlsm

[max_max]

A help?
Thank you.
Regards, max_max

[jindon]

I don't understand what you are asking and I don't like such endless change...

[max_max]

Hello jindon,
I hope to explain, unfortunately English is not my language and I do the translation with google translator.
The macro should do what makes the formula
ENGLISH: COUNTIF (B3, $ G $ 37)
ITALIAN: CONTA.SE (B3, $ G $ 37)
find cells that is similar compared to the cell G37
The macro "test" is "all" repeated numbers, the "new macro" has to find only those
I write in "cell G37" e li evidenzia.
I hope I explained.
max_max

Ciao jindon,
spero di spiegarmi, purtroppo l'inglese non è la mia lingua e la traduzione la faccio con google traduttore.
La macro deve fare quello che fa la formula
ENGLISH: COUNTIF(B3;$G$37)
ITALIANO: CONTA.SE(B3;$G$37)
cioè trovare le celle uguali rispetto alla cella G37.
La macro "test" trova "tutti" i numeri ripetuti, la "nuova macro" deve trovare solo quelli
che scrivo nella "cella G37" and highlights them.
Spero di essermi spiegato.
max_max