View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Cursor position / Cond. Format

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" wrote:

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)

"nastech" wrote in message
...
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

"Bob Phillips" wrote:

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)

"nastech" wrote in message
...
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