Posted to microsoft.public.excel.misc
|
|
Cursor position / Cond. Format
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
"Bob Phillips" wrote:
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 (ToolsAddins), not just load it.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"nastech" wrote in message
...
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
|