In Word it is possible to choose an option for a blue screen for people who
find the normal screen hard on their eyes. I have looked for this option in
Excel but can't find it. Does anyone know if it can be done (without simply
colouring the background and creating a template).

Thanks for your help
Aehan

Hi Aehan,
You could create another style under Format.
You can create and apply a style to individual cell ranges.


I don't use it at all myself but from trying it, I found...

For what you want, you would change the default (Normal style) for the
workbook. Remember to hit each OK upon leaving - after using Modify button
upon exit from modify nad again upon exiting the main styles dialog...

You cannot change the Normal default style for the entire workbook if any sheet is protected.

Style is just formatting, so changing the default pattern color (interior/background color) will
result in loss of gridlines, so you would have to use borders.

If you do a Google search: excel inurl:style
you might come up with
Jan's Excel Format & Arrange: Cell Style Dialog
http://www.jegsworks.com/Lessons/num...yle-dialog.htm

or see Rob van Gelder's reply in (it is not an add-in)
http://www.dicks-blog.com/archives/2...style-add-ins/

scope of a style applies to the workbook.

Another way might be to change your Windows defaults or check out Windows
accessibility options. NOTE: When you change the Windows colors, the changes
are global for your computer and affect all programs. It is not possible to change the
settings for individual Excel workbooks.
How to change default colors in Excel 2000
http://support.microsoft.com/?kbid=264582.

My opinion is that I would not do this unless you have a very serious problem.

If you do change the color, you probably don't want to waste color ink when printing
or make printed results hard for others to read, so you would probably want to use
File, Page Setup, Sheets, Print B&W
which will not print shading colors and will print text as black. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"aehan" wrote in message ...
In Word it is possible to choose an option for a blue screen for people who
find the normal screen hard on their eyes. I have looked for this option in
Excel but can't find it. Does anyone know if it can be done (without simply
colouring the background and creating a template).

Thanks for your help
Aehan

Thanks for your reply. I do know how to create styles and how to over-ride
the Book template, I just wondered if there was a simple setting. It isn't
for me it's for someone at work - I'll help her do it. Thankyou.

Aehan

"David McRitchie" wrote:

Hi Aehan,
You could create another style under Format.
You can create and apply a style to individual cell ranges.


I don't use it at all myself but from trying it, I found...

For what you want, you would change the default (Normal style) for the
workbook. Remember to hit each OK upon leaving - after using Modify button
upon exit from modify nad again upon exiting the main styles dialog...

You cannot change the Normal default style for the entire workbook if any sheet is protected.

Style is just formatting, so changing the default pattern color (interior/background color) will
result in loss of gridlines, so you would have to use borders.

If you do a Google search: excel inurl:style
you might come up with
Jan's Excel Format & Arrange: Cell Style Dialog
http://www.jegsworks.com/Lessons/num...yle-dialog.htm

or see Rob van Gelder's reply in (it is not an add-in)
http://www.dicks-blog.com/archives/2...style-add-ins/

scope of a style applies to the workbook.

Another way might be to change your Windows defaults or check out Windows
accessibility options. NOTE: When you change the Windows colors, the changes
are global for your computer and affect all programs. It is not possible to change the
settings for individual Excel workbooks.
How to change default colors in Excel 2000
http://support.microsoft.com/?kbid=264582.

My opinion is that I would not do this unless you have a very serious problem.

If you do change the color, you probably don't want to waste color ink when printing
or make printed results hard for others to read, so you would probably want to use
File, Page Setup, Sheets, Print B&W
which will not print shading colors and will print text as black. .

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"aehan" wrote in message ...
In Word it is possible to choose an option for a blue screen for people who
find the normal screen hard on their eyes. I have looked for this option in
Excel but can't find it. Does anyone know if it can be done (without simply
colouring the background and creating a template).

Thanks for your help
Aehan