Highlight all cells that have the same value just by clicking in one of the cells

[DanKearney]

Howdy All,

Bottom line up front: I'd like to be able to click on any of the cells in my spreadsheet that contain the word "Fuel" and have all cells
on the spreadsheet that contain the word "Fuel" to become highlighted. When I click on a cell that contains the word "Groceries"
I'd like all cells with the word "Groceries" in it to become highlighted. etc. . .

I did a search before posting and could not find anything relevant.

I am a casual Excel 2013 user and basically a neophyte, so please bear with me.

I have a spreadsheet that I use to record my expenses. I've got a range of expense categories defined.

When I add a new expense, I enter the expense category into a cell and the expense value in an adjacent cell.

Over the course of a month, I might have 10 entries for "Fuel".

I want to be able to "At a glance" see all my "Fuel" expenditures.

Thanks in advance.

Dan K.

[Special-K]

Check out Conditional Formatting or post a sample file.
Post a sample file in excel format rather than an image.

[DanKearney]

I've used conditional formatting in the spreadsheet to highlight certain things, but (Again I am a neophyte) in my example above, I only want the matching cells to highlight when I've got one of those cells selected. I've attached a test copy of the spreadsheet.

Cheers,

Dan K.

[DanKearney]

Oh well. . .

[newdoverman]

I wiped out the conditional formatting that you had on the first two worksheets so that it wouldn't be confusing as to what rules were made.
On the January worksheet:
I used A1 as the key. If you want to just click on a cell, you will need to use VBA.
I selected =$A$4:$H$33 then used Conditional Formatting, Highlight Cells Equal to.

On the second worksheet, I selected an area and used this formula
=A4=$A$1

[DanKearney]

Thanks for that effort. I see what you did.

I really don't want to become an Excel guru or VBA programmer,
so I guess I'll just live with not being able to do what I
hoped.

Cheers,

Dan K.

[TMS]

Copy this code into the Workbook Class Module.

(Press Alt-F11 to open the VBE; double click on the Workbook object in the left hand pane; copy the code into the right hand pane; save the workbook as Macro Enabled)

Please Login or Register  to view this content.

Regards, TMS

[TMS]

Please see the updated sample workbook.

Regards, TMS

[DanKearney]

TMS,

Thank you very much for your time and effort. This is exactly what I want to do.

Cheers,

Dan K.