Cursor position / Cond. Format

[Guest]

Hi, is there a formula/ way to cond. format a line / cell.. where the cursor
is currently located?

got so far for cond. format, select sheet / line, enter:
=LEFT($A1,1)+0=1

 

[Bob Phillips]

What exactly are you trying to do? Do you want to highlight the activecell,
or only show if the current cell meets a particular condition? Or something
else?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi, looking for way to hilite row cursor currently in. (might end up only
working into few cells in line that are cond. format free). otherwise, going
blind trying to skim thru sheet, doing work cannot visual all left to right,
have to place cursor on cell in question, go back to left to hilite row, to
see other items every time want to review each line... am thinking ms could
have included a hilite option that does not destroy / use up cond. formatting.

options: like hilited line when select whole row, except some blur shows;
varied thickness choice of top / bottom border lines would be good, maybe
some gray over but not blur top/bottom lines.

had received some code for temp cond. formatting, but even the one that did
not destroy other formatting, ended up destroying it after while/ doing
functions during cut-copy-paste... SEE A COND. FORMAT AS the possible
safest way to do it, short of proper programming. Thanks. code was: (was
not able to combine date code)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Static mRow As Long
If mRow <> 0 Then
Rows(mRow).Interior.ColorIndex = xlNone
End If
mRow = Target.Row
Rows(mRow).Interior.ColorIndex = 22
End Sub


XXXXXXXXXXXXXXXXXXXXXXXXXXXX

 

[Guest]

date code is:

Option Explicit
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Target.Row < 91 Then Exit Sub
If Me.Cells(.Row, "A").Value = "." Then Exit Sub
If Not Intersect(Me.Range("BB:BC"), .Cells) Is Nothing Then
Application.EnableEvents = False
With Me.Cells(.Row, "BL")
.NumberFormat = "dd"
.Value = Now
End With
Application.EnableEvents = True
End If
End With
End Sub

 

[Bob Phillips]

You should get a copy of Chip Pearson's Rowliner addin then, I think that
overlays a shape on the active row
http://www.cpearson.com/excel/RowLiner.htm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi, thanks for your info, the utility was the best choice I've seen. almost
perfect.

had conflict not sure of cause, came up with repeated blue screen-of-death..
1st might be: other running apps, (using WinXP sp2)
(maybe: FUNCRES.XLA quote price lookup app, or Askaray.com button bar
manager),
2nd: ? prob with app, lockup/ not working on left / top of half's of window
"Freeze Screen".
if have any info on proper installation, otherwise will recheck with author.
thanks.

 

[Bob Phillips]

I am afraid I know nothing about Askaray.com button bar, but I did install
Rowliner once and I always have FUNCRES.XLA running, and I do not recall any
conflicts, so I guess the former is the more likely problem. You should
install Rowliner (Tools>Addins), not just load it.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Hi, thanks, did use add-ins before, if you want to see if have tips, ideas,
... to trade (if into the market... or not.. ) can trade im names on email:
nasgentech at yahoo
thanks