Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighted cell color
How can I change the highlighted color for a range of selected cells?
-- JP |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlighted cell color
Right click sheet tabview codecopy paste this
Now whatever selection you make will be colored with number 6 Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.FormatConditions.Delete With Target .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" .FormatConditions(1).Interior.ColorIndex = 6 '35 End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "JP" wrote in message ... How can I change the highlighted color for a range of selected cells? -- JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
preventing the color in a highlighted cell from printing | Excel Discussion (Misc queries) | |||
How do I count the number of cells highlighted a certain color? | Excel Worksheet Functions | |||
formula to find out the color an excel cell is highlighted? | Excel Worksheet Functions | |||
highlighted cell color | Setting up and Configuration of Excel | |||
How do I count cells that have are highlighted a certain color? | Excel Worksheet Functions |