-
[엑셀]선택 된 셀 강조유용한 IT 2019. 4. 16. 23:49
Right click on your sheet tab, left click on View Code, and paste this in:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = -4142
Target.Interior.ColorIndex = 8
End SubOr, based on the subject line of your post:
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Cells.Interior.ColorIndex = -4142
Target.EntireRow.Interior.ColorIndex = 8
Target.EntireColumn.Interior.ColorIndex = 8
End SubIt will hilite the row and column you are in, with a shade of blue.
Highlight current row and column in all excel documents
This i smy first post here. I will try to explain the problem as clearly as possible.
a. I have several excel documents (separate xls/xlsx etc files)
b. I want to highlight current row & column (no color preference, but light BLUE does look good!) in any document that I open or create newly.
Now, I have searched on web and this forum and found this:
Excel Highlight Rows/Columns
Excel Visual Row Highlight
However, as I understand, this will work only one one sheet or workbook. I will have to put this code in all my workbooks.
How to avoid this issue? I tried putting this code in ThisWorkBook for personal.xls file.. but that also didnt work.
One more thing. I do not want to lose my existing formatting once the row/column is highlighted.'유용한 IT' 카테고리의 다른 글
[엑셀]엑셀에서 셀에 sheet명을 불러오는 함수 (0) 2018.08.22 start.siviewer.com 브라우저 납치범 제거 (0) 2017.05.18 구글검색-바이두 파일 검색하기 (0) 2016.08.20 에버노트-문서 찾기 (0) 2016.08.20 일정관리-구글 캘린더 (0) 2016.08.20