From: patrick_molloy@hotmail.com (Patrick Molloy) Newsgroups: microsoft.public.excel.misc Subject: Re: Can I highlight an active cell? Date: Thu, 21 Oct 1999 12:26:22 GMT Lines: 53 Message-ID: <380f0301.256602843@news.ml.com> References: <#qn72r0G$GA.231@cppssbbsa05> Reply-to: patrick_molloy@hotmail.comx NNTP-Posting-Host: loniw38555.uk.ml.com X-Trace: news.ml.com 940508800 25253 169.243.131.243 (21 Oct 1999 12:26:40 GMT) X-Complaints-to: usenet@news.ml.com NNTP-Posting-Date: 21 Oct 1999 12:26:40 GMT X-Newsreader: forte Free Agent 1.11/32.235 Path: cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!howland.erols.net!peerfeed.news.psi.net!nntp.psi.com!news.ml.com!not-for-mail Xref: cppssbbsa01.microsoft.com microsoft.public.excel.misc:61331 a good guide it that the column letter and row number becomes bold type. if hit the up thenthe down arrow keys, the active cell will move into the visible window if it isn't already. In Excel 97 and later you can do a trick with conditional formatting, but it does mean setting the worksheets selection change event. 1) select the range that you want to use, or even the entire sheet! 2) select from the main menu: FORMAT then CONDITIONAL FORMATTING... 3) add condition1 using formula is and set the formula to = row()=row("row") 4) select a font and pattern then click ok 5) add a second condotion =column()=cell("col") 6) select font & patterns as per (4) now if it all went well, when you move to a cell in the selected range, and hit F9, the row & column than you're in will be highlighted. it's a bore hitting F9 so right click the sheet tab and select View Code the VBE selects the selection change event for you as the default, so between the header/footer type Calculate so the module's code looks like this: Private Sub Worksheet_selectionChange(ByVal Target As Excel.range) Calculate end Sub close the editor. now select another cell. thi sforces a calculate & the row/columns change as you set ti in the format. neat or wot? Patrick On Wed, 20 Oct 1999 15:33:42 -0700, "Tina H" wrote: >I have a large spreadsheet. >I would like to be able to spot the active cell quickly. >Is there a way to have the active cell highlighted? > >