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)
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.. :-(