Value selection in 2011 Mac excel

Hi Everyone!

Here's what I am trying to do:

I would like to have all cells containing a certain value, to become highlighted (or distinguished), when ANY cell with said value is selected.
So for example:

Clicking any cell containing "apples" would cause all cells containing "apples" to become highlighted or distinguished.
I don't want to have to search for, or use conditional formatting every time.


Thanks for the help and looking forward to all the great info around here.

Robert

Originally Posted by FDibbins

Hi, welcome to the forum

I think you wuill need VBA for that, not sure how good VBA for mac is

Thanks FDibbins! I will try this and see what I get. And yeah, I am trying out excel on Mac for the first time and it is a pain!

Hi protonLeah,


Thanks for much for answering!

What specific parts of this would i have to modify to suit my actual data?

For example, If I'm simply just trying to make a cell with "apples" once clicked, cause all others to become highlighted.

I'm new to this and trying to teach myself, and don't even know where to start with all of that code.

Would it be easier to create a button when once clicked, caused all cells with "apples" to become distinguished?

Thanks!

Originally Posted by protonLeah

I don't have a Mac. I'm assuming it's similar to the PC:

With a PC there are two ways to access the VB editor

First way:
Click the Developer Tab on the ribbon
Click "Visual Basic" to start the VB editor

Alternative:
Right click the sheet tab and select "View Code"

Once the VB editor is running:
* In the project pane (left pane) double click the sheet where you want to put the code
* Paste the code into the code pane (right)

save the workbook and close the VB editor.

-------------------------------
The code that I posted looks for the all cells whose content match the clicked/selected cell. The values to find are not hard coded in the macro so it does not need any mod for that. However, I assumed that the cells would start at cell A1 and down and over for several cells all with cell A1 as the top left corner of the block.

If you click a cell in the block it will find all other cells that have the exact same contents of the selected cell.

The macro is a 'selection change' macro that runs whenever a new cell on that specific sheet is selected.

Thanks so much for taking the time to help me with this!

I followed these steps and it doesn't seem like the macro is running.

I checked to make sure everything was identical between your example and mine.

This is a copy of the excel I'm trying to get this to work in:

Maybe you could take a look? I'm starting to think it's a Mac issue.

Originally Posted by protonLeah

1. I forgot to mention that you have to save the workbook as xlsm not xlsx.
2. The original code was written as a guess at what your sheet looked like.

The modified code works on the sample provided:

Please Login or Register  to view this content.

Thanks protonLeah, your a real wizard.

It looks like "If Target.Count > 1 Or Target.Value = "" Then Exit Sub" is the part you changed.

How would I go about making it so that selecting a cell with a name in it like "Donnie" would highlight all others regardless of the other data in the cell (in this case the time frame ex: 8:00-8:30 and 12:30-1:00).

My end goal is to be able to select a cell with a client name ex: Donnie, and have all appear highlighted, regardless of the other data in the cell.

Do you think it would be easier to create buttons for all the different clients, and create a macro so that once a button is selected, it will cause all cells with the given client name to become highlighted, regardless of time or other data in cell?

Also, I'm kind of blown away by the help you've been giving me. I would love to reimburse you somehow.