PC Review


Reply
Thread Tools Rate Thread

I can't see which cell I am on...

 
 
M Skabialka
Guest
Posts: n/a
 
      16th Jun 2006
If I am working in a spreadsheet with multiple colors, as I move from cell
to cell the border is highlighted a contrasting color, e.g the border on a
turquise cell is red. This makes it easy to see which cell I am on.

But I have another spreadsheet with no background color and black text, with
many of the cells with a black border. When I am on one of those cells the
border shows as black, but you really can't tell which cell you are on
amongst all of the others outlined in black. Is there a way to use a more
vivid contrasting color, such as red, to highlight the border of the cell
you are on if it is a white cell with black contents?

Thanks,
Mich


 
Reply With Quote
 
 
 
 
=?Utf-8?B?a2Fzc2ll?=
Guest
Posts: n/a
 
      16th Jun 2006
To the left of your formula bar is an address field, which always shows your
current location on the sheet?

"M Skabialka" wrote:

> If I am working in a spreadsheet with multiple colors, as I move from cell
> to cell the border is highlighted a contrasting color, e.g the border on a
> turquise cell is red. This makes it easy to see which cell I am on.
>
> But I have another spreadsheet with no background color and black text, with
> many of the cells with a black border. When I am on one of those cells the
> border shows as black, but you really can't tell which cell you are on
> amongst all of the others outlined in black. Is there a way to use a more
> vivid contrasting color, such as red, to highlight the border of the cell
> you are on if it is a white cell with black contents?
>
> Thanks,
> Mich
>
>
>

 
Reply With Quote
 
M Skabialka
Guest
Posts: n/a
 
      16th Jun 2006
I am looking for something that will highlight the cell with a color of some
kind as I jump around the spreadsheet, the cell location, eg G87, is
meaningless.

"kassie" <(E-Mail Removed)> wrote in message
news:20857207-0E24-4EFD-BB22-(E-Mail Removed)...
> To the left of your formula bar is an address field, which always shows
> your
> current location on the sheet?
>
> "M Skabialka" wrote:
>
>> If I am working in a spreadsheet with multiple colors, as I move from
>> cell
>> to cell the border is highlighted a contrasting color, e.g the border on
>> a
>> turquise cell is red. This makes it easy to see which cell I am on.
>>
>> But I have another spreadsheet with no background color and black text,
>> with
>> many of the cells with a black border. When I am on one of those cells
>> the
>> border shows as black, but you really can't tell which cell you are on
>> amongst all of the others outlined in black. Is there a way to use a more
>> vivid contrasting color, such as red, to highlight the border of the cell
>> you are on if it is a white cell with black contents?
>>
>> Thanks,
>> Mich
>>
>>
>>



 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      17th Jun 2006
You could try Chip Pearson's ROWLINER add-in.

http://www.cpearson.com/excel/RowLiner.htm


Gord Dibben MS Excel MVP

On Fri, 16 Jun 2006 16:41:35 -0500, "M Skabialka" <(E-Mail Removed)>
wrote:

>I am looking for something that will highlight the cell with a color of some
>kind as I jump around the spreadsheet, the cell location, eg G87, is
>meaningless.
>
>"kassie" <(E-Mail Removed)> wrote in message
>news:20857207-0E24-4EFD-BB22-(E-Mail Removed)...
>> To the left of your formula bar is an address field, which always shows
>> your
>> current location on the sheet?
>>
>> "M Skabialka" wrote:
>>
>>> If I am working in a spreadsheet with multiple colors, as I move from
>>> cell
>>> to cell the border is highlighted a contrasting color, e.g the border on
>>> a
>>> turquise cell is red. This makes it easy to see which cell I am on.
>>>
>>> But I have another spreadsheet with no background color and black text,
>>> with
>>> many of the cells with a black border. When I am on one of those cells
>>> the
>>> border shows as black, but you really can't tell which cell you are on
>>> amongst all of the others outlined in black. Is there a way to use a more
>>> vivid contrasting color, such as red, to highlight the border of the cell
>>> you are on if it is a white cell with black contents?
>>>
>>> Thanks,
>>> Mich
>>>
>>>
>>>

>


Gord Dibben MS Excel MVP
 
Reply With Quote
 
M Skabialka
Guest
Posts: n/a
 
      23rd Jun 2006
I don't like the fact that this disables macros as we have a lot of them

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> You could try Chip Pearson's ROWLINER add-in.
>
> http://www.cpearson.com/excel/RowLiner.htm
>
>
> Gord Dibben MS Excel MVP
>
> On Fri, 16 Jun 2006 16:41:35 -0500, "M Skabialka"
> <(E-Mail Removed)>
> wrote:
>
>>I am looking for something that will highlight the cell with a color of
>>some
>>kind as I jump around the spreadsheet, the cell location, eg G87, is
>>meaningless.
>>
>>"kassie" <(E-Mail Removed)> wrote in message
>>news:20857207-0E24-4EFD-BB22-(E-Mail Removed)...
>>> To the left of your formula bar is an address field, which always shows
>>> your
>>> current location on the sheet?
>>>
>>> "M Skabialka" wrote:
>>>
>>>> If I am working in a spreadsheet with multiple colors, as I move from
>>>> cell
>>>> to cell the border is highlighted a contrasting color, e.g the border
>>>> on
>>>> a
>>>> turquise cell is red. This makes it easy to see which cell I am on.
>>>>
>>>> But I have another spreadsheet with no background color and black text,
>>>> with
>>>> many of the cells with a black border. When I am on one of those cells
>>>> the
>>>> border shows as black, but you really can't tell which cell you are on
>>>> amongst all of the others outlined in black. Is there a way to use a
>>>> more
>>>> vivid contrasting color, such as red, to highlight the border of the
>>>> cell
>>>> you are on if it is a white cell with black contents?
>>>>
>>>> Thanks,
>>>> Mich
>>>>
>>>>
>>>>

>>

>
> Gord Dibben MS Excel MVP



 
Reply With Quote
 
Chip Pearson
Guest
Posts: n/a
 
      23rd Jun 2006
>I don't like the fact that this disables macros as we have a lot
>of them


The RowLiner program does *not* disable macros. It does, however,
disable Undo.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"M Skabialka" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I don't like the fact that this disables macros as we have a lot
>of them
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:(E-Mail Removed)...
>> You could try Chip Pearson's ROWLINER add-in.
>>
>> http://www.cpearson.com/excel/RowLiner.htm
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Fri, 16 Jun 2006 16:41:35 -0500, "M Skabialka"
>> <(E-Mail Removed)>
>> wrote:
>>
>>>I am looking for something that will highlight the cell with a
>>>color of some
>>>kind as I jump around the spreadsheet, the cell location, eg
>>>G87, is
>>>meaningless.
>>>
>>>"kassie" <(E-Mail Removed)> wrote in message
>>>news:20857207-0E24-4EFD-BB22-(E-Mail Removed)...
>>>> To the left of your formula bar is an address field, which
>>>> always shows
>>>> your
>>>> current location on the sheet?
>>>>
>>>> "M Skabialka" wrote:
>>>>
>>>>> If I am working in a spreadsheet with multiple colors, as I
>>>>> move from
>>>>> cell
>>>>> to cell the border is highlighted a contrasting color, e.g
>>>>> the border on
>>>>> a
>>>>> turquise cell is red. This makes it easy to see which cell
>>>>> I am on.
>>>>>
>>>>> But I have another spreadsheet with no background color and
>>>>> black text,
>>>>> with
>>>>> many of the cells with a black border. When I am on one of
>>>>> those cells
>>>>> the
>>>>> border shows as black, but you really can't tell which cell
>>>>> you are on
>>>>> amongst all of the others outlined in black. Is there a way
>>>>> to use a more
>>>>> vivid contrasting color, such as red, to highlight the
>>>>> border of the cell
>>>>> you are on if it is a white cell with black contents?
>>>>>
>>>>> Thanks,
>>>>> Mich
>>>>>
>>>>>
>>>>>
>>>

>>
>> Gord Dibben MS Excel MVP

>
>



 
Reply With Quote
 
M Skabialka
Guest
Posts: n/a
 
      26th Jun 2006
That would also be a bad thing...

"Chip Pearson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> >I don't like the fact that this disables macros as we have a lot of them

>
> The RowLiner program does *not* disable macros. It does, however, disable
> Undo.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "M Skabialka" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I don't like the fact that this disables macros as we have a lot of them
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:(E-Mail Removed)...
>>> You could try Chip Pearson's ROWLINER add-in.
>>>
>>> http://www.cpearson.com/excel/RowLiner.htm
>>>
>>>
>>> Gord Dibben MS Excel MVP
>>>
>>> On Fri, 16 Jun 2006 16:41:35 -0500, "M Skabialka"
>>> <(E-Mail Removed)>
>>> wrote:
>>>
>>>>I am looking for something that will highlight the cell with a color of
>>>>some
>>>>kind as I jump around the spreadsheet, the cell location, eg G87, is
>>>>meaningless.
>>>>
>>>>"kassie" <(E-Mail Removed)> wrote in message
>>>>news:20857207-0E24-4EFD-BB22-(E-Mail Removed)...
>>>>> To the left of your formula bar is an address field, which always
>>>>> shows
>>>>> your
>>>>> current location on the sheet?
>>>>>
>>>>> "M Skabialka" wrote:
>>>>>
>>>>>> If I am working in a spreadsheet with multiple colors, as I move from
>>>>>> cell
>>>>>> to cell the border is highlighted a contrasting color, e.g the border
>>>>>> on
>>>>>> a
>>>>>> turquise cell is red. This makes it easy to see which cell I am on.
>>>>>>
>>>>>> But I have another spreadsheet with no background color and black
>>>>>> text,
>>>>>> with
>>>>>> many of the cells with a black border. When I am on one of those
>>>>>> cells
>>>>>> the
>>>>>> border shows as black, but you really can't tell which cell you are
>>>>>> on
>>>>>> amongst all of the others outlined in black. Is there a way to use a
>>>>>> more
>>>>>> vivid contrasting color, such as red, to highlight the border of the
>>>>>> cell
>>>>>> you are on if it is a white cell with black contents?
>>>>>>
>>>>>> Thanks,
>>>>>> Mich
>>>>>>
>>>>>>
>>>>>>
>>>>
>>>
>>> Gord Dibben MS Excel MVP

>>
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options Yuvraj Microsoft Excel Misc 0 29th Jun 2009 11:20 AM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Programming 1 21st Aug 2008 10:13 PM
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 tviola@wi.rr.com Microsoft Excel Worksheet Functions 0 21st Aug 2008 08:44 PM
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON CAPTGNVR Microsoft Excel Programming 2 8th Jul 2007 04:18 PM
How to create/run "cell A equals Cell B put Cell C info in Cell D =?Utf-8?B?YWJtYjE2MQ==?= Microsoft Excel Misc 5 26th Jan 2006 06:36 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:44 AM.