Select a cell -> find cell value in workbook then format

Hello,

I am looking to do this:
1. Select a cell
2. Run a macro.

This macro will:
1. Use that value (of the s to check for the re-occurrence of the value in the current worksheet as well as all other worksheets.
2. The re-occurrences of the selected cell will need to be filled with a color

Try this, tweak how you like it.
e.g. add some screenupdating true/false etc.

Please Login or Register  to view this content.

Looks good. I am getting an error on line 10 regarding a Run-time error '1004'.
the "Select method of Worksheet class failed'

this line is "wb.select"

Any idea?

---------- Post added at 02:58 PM ---------- Previous post was at 02:53 PM ----------

I am on 2011 version - MAC

Got hidden sheets?
Method doesnt work with hidden sheets, you have to skip those

You son of a gun! I just tested it and it appears to be working. I will update in a moment as to whether its application on my BOOK works. Thank you.

---------- Post added at 03:34 PM ---------- Previous post was at 03:30 PM ----------

I need an adaption. If I run the macro on the selection it makes all re-occurrences the given color. Then I move onto another value that I want adapted, and it removes the formatting on the previous cell.

Also, what is the color code for black text and light green fill?

---------- Post added at 03:39 PM ---------- Previous post was at 03:34 PM ----------

I deleted the "delete all formatting" section. That worked.

Here is a new issue: I can only add 1 character to blank cells.

---------- Post added at 03:43 PM ---------- Previous post was at 03:39 PM ----------

Character issue solved. Restarted program.

Thank you sire. Good evening.

One more question: How would I edit the code to allow for multiple (non-consecutive) value selection?