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

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

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

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

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

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