Hi


I 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, & if so, how it is done.


Any help much appreciated


cheers


jb

maybe....

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

It works for the activecell--no matter how you got there.


JB2010 wrote:

Hi

I 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, & if so, how it is done.

Any help much appreciated

cheers

jb

--

Dave Peterson

Thanks Dave

Ive seen that & 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

"Dave Peterson" wrote:

maybe....

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

It works for the activecell--no matter how you got there.


JB2010 wrote:

Hi

I 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, & if so, how it is done.

Any help much appreciated

cheers

jb

--

Dave Peterson

Bob Phillips offers an alternative using conditional formatting:

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

or

http://snipurl.com/m60t


JB2010 wrote:

Thanks Dave

Ive seen that & 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

"Dave Peterson" wrote:

maybe....

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

It works for the activecell--no matter how you got there.


JB2010 wrote:

Hi

I 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, & if so, how it is done.

Any help much appreciated

cheers

jb

--

Dave Peterson


--

Dave Peterson

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

Dave Peterson wrote:

Bob Phillips offers an alternative using conditional formatting:

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

or

http://snipurl.com/m60t

JB2010 wrote:

Thanks Dave

Ive seen that & 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

"Dave Peterson" wrote:

maybe....

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

It works for the activecell--no matter how you got there.


JB2010 wrote:

Hi

I 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, & if so, how it is done.

Any help much appreciated

cheers

jb

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson