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


And another:


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.