Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can you change the color of the selected range?
How do you change the default colour that excel applies to a selected range
of cells? I do not want to permenantly highlight them (fill them) but I do want the selected range to be more obvious? |
#2
|
|||
|
|||
Very odd request?
'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.Interior.ColorIndex = xlColorIndexNone Target.Interior.ColorIndex = 3 End Sub -- HTH RP (remove nothere from the email address if mailing direct) "Andrew" wrote in message ... How do you change the default colour that excel applies to a selected range of cells? I do not want to permenantly highlight them (fill them) but I do want the selected range to be more obvious? |
#3
|
|||
|
|||
You may want to try Chip Pearson's utility:
http://www.cpearson.com/excel/RowLiner.htm Be aware that with this (and most macros), you lose the ability to do Edit|Undo. Andrew wrote: How do you change the default colour that excel applies to a selected range of cells? I do not want to permenantly highlight them (fill them) but I do want the selected range to be more obvious? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting empty cells within a range of cells | New Users to Excel | |||
How can I change which cell is selected next, other than Down, Le. | Excel Discussion (Misc queries) | |||
Change Currency symbol dependant upon selected cell value | Excel Discussion (Misc queries) | |||
How do you change the size of a range of cells in a column/row | Charts and Charting in Excel | |||
How do I change an Excel range of cells from relative to absolute. | Excel Worksheet Functions |