#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Fill Colors

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Fill Colors

FilePage SetupSheet.

Checkmark in "Black and white"


Gord Dibben MS Excel MVP

On Fri, 13 Oct 2006 20:44:01 -0700, mlsintx
wrote:

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Fill Colors

If what you are asking is how to print your spreadsheet with no indication of
alteration whatsoever, you might prefer follow these steps instead:

1. Use the Drawing toolbar to create a rectangle covering the cell's border.

2. Format the rectangle so the line is brightly colored but there is no fill.

3. Finally, format the rectangle so it does not print - from the Format
Cells dialog box, click on the Properties tab and uncheck the "Print object"
checkbox.

I have used this method successfully. I have also used brightly colored
arrows to point to a cell,similarly formatted not to print.

Another idea is to indeed have fill on that rectangle, but set it to be
partially transparent. This option can be found when you click on "More
colors" from the place where you choose the fill color for your rectangle.

Best of luck.

"mlsintx" wrote:

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Fill Colors

In Step 3 I mean from the dialog box in which you are formatting the
object...not the Format Cells dialog box. Apologies for the mistyping.

"Certified Excel Expert" wrote:

If what you are asking is how to print your spreadsheet with no indication of
alteration whatsoever, you might prefer follow these steps instead:

1. Use the Drawing toolbar to create a rectangle covering the cell's border.

2. Format the rectangle so the line is brightly colored but there is no fill.

3. Finally, format the rectangle so it does not print - from the Format
Cells dialog box, click on the Properties tab and uncheck the "Print object"
checkbox.

I have used this method successfully. I have also used brightly colored
arrows to point to a cell,similarly formatted not to print.

Another idea is to indeed have fill on that rectangle, but set it to be
partially transparent. This option can be found when you click on "More
colors" from the place where you choose the fill color for your rectangle.

Best of luck.

"mlsintx" wrote:

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?


  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Fill Colors

select the cell you want to have a background colour in, go to the Format
menu and select conditional formatting, set 'Cell Value Is' to 'Formula Is'.
enter the formula =(which ever cell you are setting i.e. B5)="". Now press
format and set your required background colour and border etc. To copy this
to another cell ensure the cell reference is entered like B5 and not $B$5 (it
will enter $B$5 if you click on the cell when writing the formula rather than
typing B5), then select the cell which has the conditional format, click the
format painter icon (paint brush) and click on the next cell.

"mlsintx" wrote:

I want to identify where a user should enter data in a workbook/sheet. Fill
color would work great but I don't want it to print. Any ideas or
suggestions?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Colors (Text, Fill) jrs Excel Discussion (Misc queries) 0 July 29th 06 12:50 AM
Changing *permanently* Excel's colors and graph fill for charting? [email protected] Charts and Charting in Excel 2 February 24th 06 05:09 PM
Fill colors csalger55 Excel Discussion (Misc queries) 1 November 11th 05 11:31 PM
Excel: is there a way I can lighten the fill colors in a cell? Bob Tourkow Excel Discussion (Misc queries) 1 September 15th 05 03:27 PM
How to add fill colors (cell shading) in EXCEL? Donna Sherman Excel Discussion (Misc queries) 2 April 21st 05 08:24 PM


All times are GMT +1. The time now is 04:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"