Search and results display

%3CLINGO-SUB%20id%3D%22lingo-sub-1459258%22%20slang%3D%22en-US%22%3ESearch%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459258%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EThis%20is%20a%20very%20newbie%20question%2C%20I'm%20afraid%2C%20and%20I%20apologise%20for%20that.%26nbsp%3B%20I've%20no%20experience%20of%20using%20Excel%20other%20than%20reading%20the%20odd%20document%20in%20.xls%20format%20sent%20to%20me%20from%20time%20to%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I've%20now%20downloaded%20from%20the%20BBC%20an%20Excel%20workbook%20that%20shows%20the%20recommendations%20made%20by%20their%20reviewers%20in%20the%20Bulding%20a%20Library%20section%20of%20the%20weekly%20Record%20Review%20programme%20on%20the%20BBC%20Radio%203%20channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20column%20lists%20the%20composers%20in%20alphabetical%20order%2C%20the%20second%20the%20work%20reviewed%2C%20the%20third%20the%26nbsp%3B%20reviewer's%20name%2C%20the%20fourth%20the%20date%20of%20the%20broadcast%2C%20the%20fifth%20the%20reviewer's%20top%20recommendation%2C%20the%20sixth%2C%20seventh%20and%20eighth%20the%20reviewer's%20alternative%20choices%20(if%20he%20or%20she%20has%20made%20any)%20and%20finally%20the%20last%20column%20has%20a%20link%20to%20a%20podcast%20of%20the%20episode%20in%20question%2C%20if%20available.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESometimes%20there%20is%20a%20version%20of%20a%20particular%20work%20tucked%20away%20in%20the%20entry%20of%20the%20different%26nbsp%3B%20work%20that%20is%20the%20subject%20of%20the%20review.%20For%20example%2C%20Mozart's%20Sinfonia%20Concertante%20is%20one%20of%20the%20works%20incuded%20in%20the%20recommended%20disc%20of%20the%20same%20composer's%20Bassoon%20concerto.%20When%20I%20use%20the%20'Find'%20function%20to%20find%20any%20such%20subsidiary%20mention%20of%20a%20particular%20work%2C%20the%20'hit'%20cell%20is%20shown%20by%20a%20green%20coloured%20border%20that%20I%20find%20difficult%20to%20pick%20out%20on%20the%20screen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20change%20the%20border%20colour%20of%20the%20'hit'%20cell%20to%20make%20it%20more%20conspicuous%2C%20or%20even%20better%20to%20have%20the%20cell%20infill%20in%20a%20different%20colour%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1459258%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1459432%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1459432%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697789%22%20target%3D%22_blank%22%3E%40LittleValley1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20attach%20the%20spreadsheet%20we%20can%20have%20a%20look.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Epeter%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491383%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491383%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20for%20the%20delay%20in%20replying%3B%20I%20hadn't%20realised%20that%20there'd%20been%20a%20responseto%20my%20cri-de-coeur%20(no%20email%20alert%2C%20nor%20a%20spellchecker...)%3C%2FP%3E%3CP%3EAnyway%2C%20the%20file%20is%20attached%2C%20as%20suggested.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3EGlyn%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1491420%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1491420%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697789%22%20target%3D%22_blank%22%3E%40LittleValley1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20not%20out%20of%20the%20box.%20You%20may%20change%20the%20color%2Fborder%20of%20the%20active%20cell%20by%20adding%20simple%20VBA%20code%20to%20the%20workbook%2C%20e.g.%20form%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3635-excel-change-cell-color-when-clicked-selected.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F3635-excel-change-cell-color-when-clicked-selected.html%3C%2FA%3E%26nbsp%3B(you%20may%20google%20for%20other%20variants)%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3EPrivate%20Sub%20Worksheet_SelectionChange(ByVal%20Target%20As%20Range)%0A%20%20%20%20With%20Target%0A%20%20%20%20%20%20%20%20.Worksheet.Cells.FormatConditions.Delete%0A%20%20%20%20%20%20%20%20.FormatConditions.Add%20xlExpression%2C%20%2C%20%22TRUE%22%0A%20%20%20%20%20%20%20%20.FormatConditions(1).Interior.Color%20%3D%20vbYellow%0A%20%20%20%20End%20With%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3EIt%20changes%20behaviour%20on%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20474px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201269iE449DFCB25A9F0C0%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1492388%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1492388%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697789%22%20target%3D%22_blank%22%3E%40LittleValley1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Glyn%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20solution%20suggested%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20will%20definitely%20work%20but%20as%20you%20are%20an%20excel%20newbie%20I%20would%20guess%20that%20you%20do%20not%20understand%20it.%3C%2FP%3E%3CP%3EHowever%2C%20if%20I%20understand%20your%20problem%20correctly%20a%20more%20simple%20solution%20is%20look%20at%20the%20box%20at%20the%20top%20left%20corner%20and%20that%20will%20tell%20you%20the%20CURRENT%26nbsp%3B%20cell.%3C%2FP%3E%3CP%3EIn%20the%20example%20below%2C%20I%20searched%20for%20Mozart%20and%20the%20first%20occurence%20was%20inn%20Cell%20E107.%20Look%20at%20the%20box%20in%20the%20top%20left%20(highlighted%20in%20yellow)%20and%20that%20will%20tell%20you%20the%20current%20cell%20where%20Mozart%20is%20to%20be%20found.%20Hope%20that%20helps%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPeter%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22peteryac60_1-1593185786455.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F201328i61771306C80FAB67%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22peteryac60_1-1593185786455.png%22%20alt%3D%22peteryac60_1-1593185786455.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494622%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494622%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F667968%22%20target%3D%22_blank%22%3E%40peteryac60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Peter%20for%20drawing%20my%20attention%20to%20what%20was%20under%20my%20nose!%20It%20certainly%20works%20well%20enough%20for%20my%20purposes.%3C%2FP%3E%3CP%3EGlyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494624%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494624%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20Sergei%20for%20your%20response.%20I've%20decided%20for%20the%20moment%20to%20stick%20with%20Peter's%20suggestion%2C%20but%20if%20I%20feel%20adventurous%20one%20day%20I'll%20certainly%20try%20yours%20out.%3C%2FP%3E%3CP%3EGlyn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1494659%22%20slang%3D%22en-US%22%3ERe%3A%20Search%20and%20results%20display%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1494659%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F697789%22%20target%3D%22_blank%22%3E%40LittleValley1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGlyn%2C%20of%20course%2C%20use%20the%20solution%20with%20which%20you%20are%20most%20comfortable.%20In%20Excel%20everything%20could%20be%20done%20by%20several%20ways.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello

This is a very newbie question, I'm afraid, and I apologise for that.  I've no experience of using Excel other than reading the odd document in .xls format sent to me from time to time.

 

However, I've now downloaded from the BBC an Excel workbook that shows the recommendations made by their reviewers in the Bulding a Library section of the weekly Record Review programme on the BBC Radio 3 channel.

 

The first column lists the composers in alphabetical order, the second the work reviewed, the third the  reviewer's name, the fourth the date of the broadcast, the fifth the reviewer's top recommendation, the sixth, seventh and eighth the reviewer's alternative choices (if he or she has made any) and finally the last column has a link to a podcast of the episode in question, if available.

 

Sometimes there is a version of a particular work tucked away in the entry of the different  work that is the subject of the review. For example, Mozart's Sinfonia Concertante is one of the works incuded in the recommended disc of the same composer's Bassoon concerto. When I use the 'Find' function to find any such subsidiary mention of a particular work, the 'hit' cell is shown by a green coloured border that I find difficult to pick out on the screen.

 

Is it possible to change the border colour of the 'hit' cell to make it more conspicuous, or even better to have the cell infill in a different colour?

 

7 Replies
Highlighted

@LittleValley1 

 

if you attach the spreadsheet we can have a look.

 

thanks

 

peter

Highlighted

@peteryac60 

 

Sorry for the delay in replying; I hadn't realised that there'd been a responseto my cri-de-coeur (no email alert, nor a spellchecker...)

Anyway, the file is attached, as suggested.

Thanks

Glyn

 

Highlighted

@LittleValley1 

That's not out of the box. You may change the color/border of the active cell by adding simple VBA code to the workbook, e.g. form here https://www.extendoffice.com/documents/excel/3635-excel-change-cell-color-when-clicked-selected.html (you may google for other variants)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    With Target
        .Worksheet.Cells.FormatConditions.Delete
        .FormatConditions.Add xlExpression, , "TRUE"
        .FormatConditions(1).Interior.Color = vbYellow
    End With
End Sub

It changes behaviour on

image.png

Highlighted

@LittleValley1 

Hi Glyn,

 

The solution suggested by @Sergei Baklan  will definitely work but as you are an excel newbie I would guess that you do not understand it.

However, if I understand your problem correctly a more simple solution is look at the box at the top left corner and that will tell you the CURRENT  cell.

In the example below, I searched for Mozart and the first occurence was inn Cell E107. Look at the box in the top left (highlighted in yellow) and that will tell you the current cell where Mozart is to be found. Hope that helps you.

 

Peter

 

peteryac60_1-1593185786455.png

 

 

 

Highlighted

@peteryac60 

 

Thank you Peter for drawing my attention to what was under my nose! It certainly works well enough for my purposes.

Glyn

Highlighted

@Sergei Baklan 

 

Thank you Sergei for your response. I've decided for the moment to stick with Peter's suggestion, but if I feel adventurous one day I'll certainly try yours out.

Glyn

Highlighted

@LittleValley1 

Glyn, of course, use the solution with which you are most comfortable. In Excel everything could be done by several ways.