ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change appearance of selected cells in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/190444-how-change-appearance-selected-cells-excel.html)

Alan Howes

How to change appearance of selected cells in Excel
 
So did Zarrar ever resolve her problem? I guess not. Seems MS has changed the
behaviour of Excel 2007 so that selected cells do not change colour. Which is
very annoying, particularly in discontinuous ranges. I would dearly like a
fix.

Bernard Liengme

How to change appearance of selected cells in Excel
 
Selected cells Do change colour in XL2007
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Alan Howes" <Alan wrote in message
...
So did Zarrar ever resolve her problem? I guess not. Seems MS has changed
the
behaviour of Excel 2007 so that selected cells do not change colour. Which
is
very annoying, particularly in discontinuous ranges. I would dearly like a
fix.



Rick Rothstein \(MVP - VB\)[_632_]

How to change appearance of selected cells in Excel
 
I would point out, however, that the shading used is not as prominent as the
shading in XL2003 and earlier versions. This is not really a problem with a
contiguous selection as there is a very visible border around the selection;
but, with non-contiguous selections, there is only this very pale (maybe
purplish) shading to indicate the selected areas which, to me, does not
stand out anywhere as well as the not-as-pale (bluish) shading used in
XL2003 and earlier versions.

Rick


"Bernard Liengme" wrote in message
...
Selected cells Do change colour in XL2007
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Alan Howes" <Alan wrote in message
...
So did Zarrar ever resolve her problem? I guess not. Seems MS has changed
the
behaviour of Excel 2007 so that selected cells do not change colour.
Which is
very annoying, particularly in discontinuous ranges. I would dearly like
a
fix.




Alan Howes[_2_]

How to change appearance of selected cells in Excel
 
Thanks Rick - Having looked at my screen VERY carefully, yes indeed there is
a change of colour - but it is indeed very faint, at least on my screen. I
often use GoTo|Special|etc to select types of cell contents for one reason or
another, and in these cases, with scattered cells, it's difficult to check
whether you have what you want or not.

But I guess this is something we just have to live with (like the fact that
if you change the boldness or colour of PART of the text in a cell, it gets a
point or two smaller ...).

Cheers, Alan

"Rick Rothstein (MVP - VB)" wrote:

I would point out, however, that the shading used is not as prominent as the
shading in XL2003 and earlier versions. This is not really a problem with a
contiguous selection as there is a very visible border around the selection;
but, with non-contiguous selections, there is only this very pale (maybe
purplish) shading to indicate the selected areas which, to me, does not
stand out anywhere as well as the not-as-pale (bluish) shading used in
XL2003 and earlier versions.

Rick


"Bernard Liengme" wrote in message
...
Selected cells Do change colour in XL2007
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Alan Howes" <Alan wrote in message
...
So did Zarrar ever resolve her problem? I guess not. Seems MS has changed
the
behaviour of Excel 2007 so that selected cells do not change colour.
Which is
very annoying, particularly in discontinuous ranges. I would dearly like
a
fix.





Rick Rothstein \(MVP - VB\)[_635_]

How to change appearance of selected cells in Excel
 
You might have the brightness on your monitor set too high... doing that
will make the tinted selections look lighter.

Rick


"Alan Howes" wrote in message
...
Thanks Rick - Having looked at my screen VERY carefully, yes indeed there
is
a change of colour - but it is indeed very faint, at least on my screen. I
often use GoTo|Special|etc to select types of cell contents for one reason
or
another, and in these cases, with scattered cells, it's difficult to check
whether you have what you want or not.

But I guess this is something we just have to live with (like the fact
that
if you change the boldness or colour of PART of the text in a cell, it
gets a
point or two smaller ...).

Cheers, Alan

"Rick Rothstein (MVP - VB)" wrote:

I would point out, however, that the shading used is not as prominent as
the
shading in XL2003 and earlier versions. This is not really a problem with
a
contiguous selection as there is a very visible border around the
selection;
but, with non-contiguous selections, there is only this very pale (maybe
purplish) shading to indicate the selected areas which, to me, does not
stand out anywhere as well as the not-as-pale (bluish) shading used in
XL2003 and earlier versions.

Rick


"Bernard Liengme" wrote in message
...
Selected cells Do change colour in XL2007
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Alan Howes" <Alan wrote in message
...
So did Zarrar ever resolve her problem? I guess not. Seems MS has
changed
the
behaviour of Excel 2007 so that selected cells do not change colour.
Which is
very annoying, particularly in discontinuous ranges. I would dearly
like
a
fix.






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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com