Office & Productivity Software forum

General discussion

Make Excel always highlight an active cell.

by dover2796 / January 17, 2005 7:24 AM PST

Win XP Pro; Office 2000 (Premium)

I've cussed at this pet peeve for three years.

When using Ctrl-F to find a word or phrase in a worksheet, Excel jumps to the first result but it doesn't highlight it like Word does. Excel just makes the active cell's border fatter, which is no bloody help at all because it's barely noticable.

Is there a way I can change the way Excel displays an active cell? I'd like it to highlight the whole cell with some colour or other or even just black with white font or something. I tried changing the Windows Display properties in Control Panel but that didn't work.

So-o-o...with fingers crossed, I say thanks in advance for any help.


Post a reply
Discussion is locked
You are posting a reply to: Make Excel always highlight an active cell.
The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our CNET Forums policies for details. All submitted content is subject to our Terms of Use.
Track this discussion and email me when there are updates

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

You are reporting the following post: Make Excel always highlight an active cell.
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Collapse -
Hi Dover
by MarkFlax Forum moderator / January 18, 2005 9:32 PM PST

I've been puzzling over your problem for a couple of days, and I haven't really come up with a solution.

I suspect that you will need some sort of Visual Basic Macro. Something which changes the properties of the cell when it is active, or highlighted. But I'm not a VB man myself.

Microsoft have very good newsgroup site, (browser based), here where you can search for people who had similar questions, or post a question yourself.

Or perhaps swisse, on these forums may pick this up and give you advice. He's a wiz on VB programming.

I have found a method that might work for you, but it's a workaround, and may need careful tweaking and positioning to get it to look right and work well.

It uses Conditional Formatting, (Format > Conditional Formatting).

You can format any cell's properties to change when a condition is met. So, if you set a cell (or group of cells), to point to a target cell, (note, I don't mean the contents of the cells, just the conditional formatting), and format the cell or cells to change background color if the contents of the target cell equals that of the formatted cells, then the color of the formatted cells wil, change.


Cell A1 is the target cell. In this cell you type in the value or expression you want to search for, instead of using the Find function.

Cells B1 to B5 hold the following values;


Then highlight cells B1 to B5, goto Conditional Formatting, and select Condition 1 "Cell Value is", "equal to", =$A$1, then click the Format button to select how you want the property of the cells to change

You can select Condition 2, (click the "Add" button), to reset the formatting if the target cell is blank, (although it isn't necessary).

In this way, you can use cell A1, (or whatever cell you want), as your Find function, and conditionally format "all" the cells that you need to be highlighted if the contents of A1 matches any of the other cells.

I have just tried a little demonstration and it works, but this may not be what you want.

Let me know if this helps in any way.


Collapse -
Here's a solution:
by Kees Bakker / January 19, 2005 3:36 AM PST
Collapse -
Search Macro
by swisse / January 19, 2005 5:51 AM PST

Hello dover,
Here is a search macro I wrote. The problem is - it highlights only the first found instance of the searched word. Maybe I could improve it later to highlight also other found queries. Anyway, try it, but I presume that you have some working knowledge of macros, and would rather put it in an empty module:

Sub SearchAndHighlight()
Dim ThisArea As Range, SearchMe As String
SearchMe = InputBox("Write here what you're looking for.")
If IsEmpty(SearchMe) Then Exit Sub
Set ThisArea = Sheets("Sheet1").Cells.Find(SearchMe, lookat:=xlWhole)
If ThisArea Is Nothing Then
MsgBox SearchMe & " - " & "There is no such entry."
Cells.Interior.ColorIndex = xlColorIndexNone
ThisArea.Interior.ColorIndex = 6
End If
End Sub


Collapse -
Highlight active cell
by peernisse / October 7, 2015 9:47 AM PDT

This will highlight the active cell light blue as you move around the sheet. Use Alt+F11 to open VBA, select the sheet of interest on the left and add in the the VBA below. Need to save the workbook as a .xlsm.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Application.ScreenUpdating = False
'Clear the color of all cells
Cells.Interior.ColorIndex = 0
' Highlight the active cell
Target.Interior.ColorIndex = 20
Application.ScreenUpdating = True

End Sub


Collapse -
That's smart.
by Kees_B Forum moderator / October 9, 2015 2:18 AM PDT
In reply to: Highlight active cell

If you put it in your personal macro file, it will work in all sheets in all workbooks (which are enabled for macro's). But that might be more than you want.


Collapse -
Smart, perhaps
by MarkFlax Forum moderator / October 9, 2015 3:14 AM PDT
In reply to: That's smart.

but I am not sure how usable it would be for the OP in this 2005 discussion.

EG, xlsm files were not available for Office 2000 in 2005.

Poster's really should look and understand whether their replies to long finished discussions are appropriate! Devil


Collapse -
Active Cell Outline Color
by jblue632002 / November 12, 2015 11:53 PM PST
In reply to: Highlight active cell

I am having same problem with having active cell highlight in a different border color. I am working in Excel 2010. I copied and pasted the VB code and choose option to apply to entire workbook. I saved the workbook as an .xlsm document. What I would like to be able to do: (1) tab from cell to cell and have the border around any given cell be a different color than the rest of the gridlines; (2) I do not want to change color of all other gridlines, just want the border around the active cell to be a different color in order to be more visible; (3) Would like to be able to keep any cell shading that already exist in any cell.

Popular Forums
Computer Help 49,613 discussions
Computer Newbies 10,349 discussions
Laptops 19,436 discussions
Security 30,426 discussions
TVs & Home Theaters 20,308 discussions
Windows 10 360 discussions
Phones 15,802 discussions
Windows 7 7,351 discussions
Networking & Wireless 14,641 discussions

CNET Holiday Gift Guide

Looking for great gifts under $100?

Trendy tech gifts don't require a hefty price tag. Choose from these CNET-recommended useful and high-quality gadgets.