ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do i change the selected cells color (https://www.excelbanter.com/new-users-excel/133625-how-do-i-change-selected-cells-color.html)

Asofio

how do i change the selected cells color
 
When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?

Gary''s Student

how do i change the selected cells color
 
Put the following macro in worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
End Sub

--
Gary''s Student
gsnu200709


"Asofio" wrote:

When i select cells in exel 2007 i don´t see the color it´s almost withe can
it be changed ?



All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com