?

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.