Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Excel 2007 - Is there a way to change the color of the selecting shade to make it easier to see?
In Excel 2007, I'm selecting a group of cells, but it's difficult to distiguish it from the non-selected cells. Is there a way to change the selecting shade? I'm not asking to fill the background. I'm talking about the selecting (or blocking) part. I hope this makes sense.
When I'm blocking (or selecting) one (or many) cell(s), I get a very light grey shading that's not different from the white of the non-selected cells. How do I change the color of the selected (blocked) cells in order to make it more noticeable?
I'm not talking about filling in color to the cell. I'm talking about when you're grabbing a bunch of cells and you want to see what you've grabbed when you're looking at the spreadsheet. I can't see what I've blocked. Why don't they call it blocking like they used to? Shading sounds like I'm talking about filling in w/ background color, and I'm not.
3 Answers
- 1 decade agoFavorite Answer
From my knowledge of MS Excel, there is no option to pick the color of selected cells. You do however have the option to change the color of the selected cells using VBA code.
Here are some simple instructions.
On the sheet you want the highlighted colors changed on...
* Press Alt-F11 to get to the Visual Basic Editor
* On the left side under VBAProject, double click on the sheet to change
* Paste the following code on the right hand side
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.FormatConditions.Delete
With Target
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 17
End With
End Sub
* Change the ColorIndex to any color you like. Use http://www.mvps.org/dmcritchie/excel/colors.htm to pick your colors.
* Close the Visual Basic Editor
* Now try selecting cells on that sheet.
* Duplicate this on every sheet you want your colors changed.
Source(s):
cougar548 on http://www.techsupportforum.com/microsoft-support/... http://www.mvps.org/dmcritchie/excel/colors.htm
- Paul FLv 61 decade ago
When Selecting (Highlighting) a group of cells, a border appears around the selected cells, and all but the first are shaded.
Is this what you mean?
