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
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
>
>
>
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" <kassie@discussions.microsoft.com> wrote in message
news:20857207-0E24-4EFD-BB22-EAC2D7EA5001@microsoft.com...
> 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
>>
>>
>>
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" <mskabialka@NOSPAMdrc.com>
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" <kassie@discussions.microsoft.com> wrote in message
>news:20857207-0E24-4EFD-BB22-EAC2D7EA5001@microsoft.com...
>> 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
I don't like the fact that this disables macros as we have a lot of them
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:12g692lng5bvijtghus5dn802o6mr3frot@4ax.com...
> 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"
> <mskabialka@NOSPAMdrc.com>
> 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" <kassie@discussions.microsoft.com> wrote in message
>>news:20857207-0E24-4EFD-BB22-EAC2D7EA5001@microsoft.com...
>>> 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
>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" <mskabialka@NOSPAMdrc.com> wrote in message
news:umRnhVslGHA.4244@TK2MSFTNGP02.phx.gbl...
>I don't like the fact that this disables macros as we have a lot
>of them
>
> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
> news:12g692lng5bvijtghus5dn802o6mr3frot@4ax.com...
>> 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"
>> <mskabialka@NOSPAMdrc.com>
>> 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" <kassie@discussions.microsoft.com> wrote in message
>>>news:20857207-0E24-4EFD-BB22-EAC2D7EA5001@microsoft.com...
>>>> 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
>
>
That would also be a bad thing...
"Chip Pearson" <chip@cpearson.com> wrote in message
news:OxJ1dbslGHA.884@TK2MSFTNGP05.phx.gbl...
> >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" <mskabialka@NOSPAMdrc.com> wrote in message
> news:umRnhVslGHA.4244@TK2MSFTNGP02.phx.gbl...
>>I don't like the fact that this disables macros as we have a lot of them
>>
>> "Gord Dibben" <gorddibbATshawDOTca> wrote in message
>> news:12g692lng5bvijtghus5dn802o6mr3frot@4ax.com...
>>> 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"
>>> <mskabialka@NOSPAMdrc.com>
>>> 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" <kassie@discussions.microsoft.com> wrote in message
>>>>news:20857207-0E24-4EFD-BB22-EAC2D7EA5001@microsoft.com...
>>>>> 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
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks