If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Active Cell Color
Hi!
Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
#2
|
|||
|
|||
Active Cell Color
Chip Pearson has a utility on his site that does what you want.
www.cpearson.com Unfortunately, his site appears to be down at this moment. If you check it in a little while it might be back on line "Taurien" wrote: Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
#3
|
|||
|
|||
Active Cell Color
i checked that site but still its not working, is there any other way around .
Thanks "Duke Carey" wrote: Chip Pearson has a utility on his site that does what you want. www.cpearson.com Unfortunately, his site appears to be down at this moment. If you check it in a little while it might be back on line "Taurien" wrote: Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
#4
|
|||
|
|||
Active Cell Color
It's up and running now
http://www.cpearson.com/Excel/RowLiner.htm "Taurien" wrote: i checked that site but still its not working, is there any other way around . Thanks "Duke Carey" wrote: Chip Pearson has a utility on his site that does what you want. www.cpearson.com Unfortunately, his site appears to be down at this moment. If you check it in a little while it might be back on line "Taurien" wrote: Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
#5
|
|||
|
|||
Active Cell Color
Chip's rowliner is probably your best bet but it won't work on protected
worksheets. This sheet event code is similar and can work on a protected sheet. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Static OldCell As Range If Application.CutCopyMode = 0 Then ActiveSheet.Unprotect Password:="justme" If Not OldCell Is Nothing Then OldCell.Interior.ColorIndex = xlColorIndexNone OldCell.Borders.LineStyle = xlLineStyleNone End If Set OldCell = Target OldCell.Interior.ColorIndex = 6 OldCell.Borders.LineStyle = xlContinuous Else If OldCell Is Nothing Then Set OldCell = Target Else Set OldCell = Union(OldCell, Target) End If End If ActiveSheet.Protect Password:="justme" End Sub Will color the activecell yellow. Note: will wipe out existing background color of activecell cell unless BG color is due to CF Gord Dibben MS Excel MVP On Wed, 27 Aug 2008 04:29:00 -0700, Taurien wrote: Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
#6
|
|||
|
|||
Active Cell Color
great man it worked and its fun alongwith .. thanks
"Duke Carey" wrote: It's up and running now http://www.cpearson.com/Excel/RowLiner.htm "Taurien" wrote: i checked that site but still its not working, is there any other way around . Thanks "Duke Carey" wrote: Chip Pearson has a utility on his site that does what you want. www.cpearson.com Unfortunately, his site appears to be down at this moment. If you check it in a little while it might be back on line "Taurien" wrote: Hi! Any function by which we can have active cell as colored or defferent from other cells as usually we have to look at the row and column on top as its highlighted. So any function by which a cell is colored. Regards |
Thread Tools | |
Display Modes | |
|
|