software

HiI want to apply some way of keeping the formatting of an established
spreadsheet the same but changing it in the 'Active' highlighted cell only,
so that if i came onto the sheet at a specific cell from a hyperlink, the
cell that it took me to (the active one) would stand out from the rest of the
sheet.

Can anyone let me know if such thing is possible, amp; if so, how it is done.Any help much appreciatedcheersjb

maybe....

you may want to try Chip Pearson's Rowliner:
www.cpearson.com/excel/RowLiner.htm

It works for the activecell--no matter how you got there.JB2010 wrote:
gt;
gt; Hi
gt;
gt; I want to apply some way of keeping the formatting of an established
gt; spreadsheet the same but changing it in the 'Active' highlighted cell only,
gt; so that if i came onto the sheet at a specific cell from a hyperlink, the
gt; cell that it took me to (the active one) would stand out from the rest of the
gt; sheet.
gt;
gt; Can anyone let me know if such thing is possible, amp; if so, how it is done.
gt;
gt; Any help much appreciated
gt;
gt; cheers
gt;
gt; jb

--

Dave Peterson

Thanks Dave

Ive seen that amp; it look like it would be close to what i need, but i wont be
allowed to download anything like that onto my office machine.

Do you know any way to get the macro code for it?cheers

jb

quot;Dave Petersonquot; wrote:

gt; maybe....
gt;
gt; you may want to try Chip Pearson's Rowliner:
gt; www.cpearson.com/excel/RowLiner.htm
gt;
gt; It works for the activecell--no matter how you got there.
gt;
gt;
gt; JB2010 wrote:
gt; gt;
gt; gt; Hi
gt; gt;
gt; gt; I want to apply some way of keeping the formatting of an established
gt; gt; spreadsheet the same but changing it in the 'Active' highlighted cell only,
gt; gt; so that if i came onto the sheet at a specific cell from a hyperlink, the
gt; gt; cell that it took me to (the active one) would stand out from the rest of the
gt; gt; sheet.
gt; gt;
gt; gt; Can anyone let me know if such thing is possible, amp; if so, how it is done.
gt; gt;
gt; gt; Any help much appreciated
gt; gt;
gt; gt; cheers
gt; gt;
gt; gt; jb
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Bob Phillips offers an alternative using conditional formatting:

groups.google.co.uk/group/mic...7f54b5750d83b9

or

snipurl.com/m60tJB2010 wrote:
gt;
gt; Thanks Dave
gt;
gt; Ive seen that amp; it look like it would be close to what i need, but i wont be
gt; allowed to download anything like that onto my office machine.
gt;
gt; Do you know any way to get the macro code for it?
gt;
gt; cheers
gt;
gt; jb
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; maybe....
gt; gt;
gt; gt; you may want to try Chip Pearson's Rowliner:
gt; gt; www.cpearson.com/excel/RowLiner.htm
gt; gt;
gt; gt; It works for the activecell--no matter how you got there.
gt; gt;
gt; gt;
gt; gt; JB2010 wrote:
gt; gt; gt;
gt; gt; gt; Hi
gt; gt; gt;
gt; gt; gt; I want to apply some way of keeping the formatting of an established
gt; gt; gt; spreadsheet the same but changing it in the 'Active' highlighted cell only,
gt; gt; gt; so that if i came onto the sheet at a specific cell from a hyperlink, the
gt; gt; gt; cell that it took me to (the active one) would stand out from the rest of the
gt; gt; gt; sheet.
gt; gt; gt;
gt; gt; gt; Can anyone let me know if such thing is possible, amp; if so, how it is done.
gt; gt; gt;
gt; gt; gt; Any help much appreciated
gt; gt; gt;
gt; gt; gt; cheers
gt; gt; gt;
gt; gt; gt; jb
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

And I just saw this posted by J.E. McGimpsey:
www.mcgimpsey.com/excel/highl...iteRetainColor

Dave Peterson wrote:
gt;
gt; Bob Phillips offers an alternative using conditional formatting:
gt;
gt; groups.google.co.uk/group/mic...7f54b5750d83b9
gt;
gt; or
gt;
gt; snipurl.com/m60t
gt;
gt; JB2010 wrote:
gt; gt;
gt; gt; Thanks Dave
gt; gt;
gt; gt; Ive seen that amp; it look like it would be close to what i need, but i wont be
gt; gt; allowed to download anything like that onto my office machine.
gt; gt;
gt; gt; Do you know any way to get the macro code for it?
gt; gt;
gt; gt; cheers
gt; gt;
gt; gt; jb
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; maybe....
gt; gt; gt;
gt; gt; gt; you may want to try Chip Pearson's Rowliner:
gt; gt; gt; www.cpearson.com/excel/RowLiner.htm
gt; gt; gt;
gt; gt; gt; It works for the activecell--no matter how you got there.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; JB2010 wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Hi
gt; gt; gt; gt;
gt; gt; gt; gt; I want to apply some way of keeping the formatting of an established
gt; gt; gt; gt; spreadsheet the same but changing it in the 'Active' highlighted cell only,
gt; gt; gt; gt; so that if i came onto the sheet at a specific cell from a hyperlink, the
gt; gt; gt; gt; cell that it took me to (the active one) would stand out from the rest of the
gt; gt; gt; gt; sheet.
gt; gt; gt; gt;
gt; gt; gt; gt; Can anyone let me know if such thing is possible, amp; if so, how it is done.
gt; gt; gt; gt;
gt; gt; gt; gt; Any help much appreciated
gt; gt; gt; gt;
gt; gt; gt; gt; cheers
gt; gt; gt; gt;
gt; gt; gt; gt; jb
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson