?

Log in

No account? Create an account
 
 
13 September 2012 @ 12:51 pm
MS Excel: Making the selected cell stand out more?  
I was asked yesterday if there was any way in Excel to make the selected cell stand out more -- something more than just the heavy border around the cell, especially when there are already cell borders which may mask that.

The question arose in relation to finding the selected cell when someone searches for information in a spreadsheet.

I thought there might be something in accessibility, but I don't see anything helpful.

The only thing I can think, if the person is using 2007 or 2010 with the ribbon, would be to do the search and click one of the "cell formatting" options in the ribbon to make the cell stand out, then do ctrl-z to undo the formatting. That doesn't seem like a really good workaround, though.

Any ideas?

(crossposted to various places, including my own LJ, my Facebook, and my IAAP chapter listserv)
 
 
 
Xiphias Gladiusxiphias on September 13th, 2012 04:59 pm (UTC)
Is there some option in Cell Format Font for adjusting the color of the font? Might that help? I just tried on my old, outdated version, and, in that, I could alternate-click on the cell, Format Cells..., and then choose colors on Font and Fill.

Can you still that, and would that work?
Janet Miles, CAP-OMjanetmiles on September 13th, 2012 05:47 pm (UTC)
That does work, but I was hoping for some setting that would cause the selected cell to default to some more visible format.
what doesn't kill me better runcarlyinrome on September 13th, 2012 05:14 pm (UTC)

Couldn't you just "highlight" the cell by changing the background color of the cell to yellow (or whatever color you prefer)?



I'm not entirely sure how that would translate to the ribbon, though.

seawasp: Poisonous&Venomousseawasp on September 13th, 2012 05:29 pm (UTC)
You can color each individual cell to different colors, or change the font. I'm not sure if that will help you.
Janet Miles, CAP-OMjanetmiles on September 13th, 2012 05:47 pm (UTC)
That does work, but I was hoping for some setting that would cause the selected cell to default to some more visible format.
Janet Miles, CAP-OMjanetmiles on September 13th, 2012 05:47 pm (UTC)
That does work, but I was hoping for some setting that would cause the selected cell to default to some more visible format.
Cat Sitting Stillcatsittingstill on September 13th, 2012 07:26 pm (UTC)
By "more visible format" you seem to mean something more than "make this cell stand out from the others" because yellow highlighting would do that just fine.

Do you want the cell to contain bolder font? A larger font? A less busy font?
Janet Miles, CAP-OMjanetmiles on September 13th, 2012 07:38 pm (UTC)
I think I'm explaining it wrong.

I don't want to make *a specific cell* more visible. I want to make *whatever cell the cursor is in* more visible, and to have that visibility follow the cursor from cell to cell around the worksheet.

Is that different from what I was asking before?

I think rahirah's answer below is what I'm looking for (although it's probably too advanced for the user who contacted us).
Cat Sitting Stillcatsittingstill on September 13th, 2012 10:31 pm (UTC)
OH. Perhaps it's not that it's different from what you said before, but that I now *understand* what you said before. I had the impression you wanted to select a cell, make it more visible, and move on, leaving the highly visible cell still highly visible while you selected other cells. My bad.

I'm sorry; I have no idea how to do what you have in mind.. :-(
Barbrahirah on September 13th, 2012 06:23 pm (UTC)
Looks like you need VBA code to do this. Here is a link with an example:

http://www.pcreview.co.uk/forums/change-format-active-cell-t4038481.html

And another:

http://www.msofficegurus.com/post/Excel-Highlight-the-Active-Cell.aspx

Edited at 2012-09-13 06:24 pm (UTC)
Janet Miles, CAP-OMjanetmiles on September 13th, 2012 07:50 pm (UTC)
This appears to be what I'm looking for. I'm not sure it's helpful to the user who contacted us, but it does solve the problem.

Thanks!
My Yuki's Fan Clubakcipitrokulo on September 14th, 2012 12:20 pm (UTC)
Use conditional formatting on all cells that will change the formatting to something noticable (font, bold, colour, etc) if it is equal to the value in another cell: have this one (near the top, above a freeze if present) marked as the "search" cell.
My Yuki's Fan Clubakcipitrokulo on September 14th, 2012 12:21 pm (UTC)
Ah - misunderstood what you were asking, sorry!