How To Highlight in Excel

S

spindeldase

Hi

I am making an Excel template for others to use, now i
have locked areas
where users shoudn´t be abel to write in, but i still
want to make it clear
for users where they can enter data, to make it easier to
fill out the form.
I have tried to insert an rectangular object that i paint
yellow over cells
that i want people to be able to change, then i make the
object
non-printable (Cause i don´t want theese areas to look
different when user
print out the form), but when i ad the object it comes
over the cells ... so
i can´t choose those cells with the mouse, only with
TAB,.... this is my
problem... i hope you understand it.

Is there anyother solotion or should i just do something
in the above
different?
What i want: make my spreadsheet easier to fill ... but
when user print it
... i want it just black and white no other colors.

Regards

dase
 
T

Trevor Shuttleworth

Dase

If the cells where you want to enter data are unlocked and the others are
locked, you can use Conditional Formatting to highlight the data entry
cells.

Use:

Formula is: =NOT(CELL("Protect",D11)), for example, and set the background
colour to something like a pale yellow. Select the Patterns tab and choose
a suitable colour.

Regards

Trevor


Hi

I am making an Excel template for others to use, now i
have locked areas
where users shoudn´t be abel to write in, but i still
want to make it clear
for users where they can enter data, to make it easier to
fill out the form.
I have tried to insert an rectangular object that i paint
yellow over cells
that i want people to be able to change, then i make the
object
non-printable (Cause i don´t want theese areas to look
different when user
print out the form), but when i ad the object it comes
over the cells ... so
i can´t choose those cells with the mouse, only with
TAB,.... this is my
problem... i hope you understand it.

Is there anyother solotion or should i just do something
in the above
different?
What i want: make my spreadsheet easier to fill ... but
when user print it
... i want it just black and white no other colors.

Regards

dase
 
F

Frank Kabel

Hi
I would fill these cells with a color. For printing record a macro
whcih first sets the color to 'none' and then prints the sheet and sets
the color agaian. ssign this macro to a toolbar icon and use this macro
for printing

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag Hi

I am making an Excel template for others to use, now i
have locked areas
where users shoudn´t be abel to write in, but i still
want to make it clear
for users where they can enter data, to make it easier to
fill out the form.
I have tried to insert an rectangular object that i paint
yellow over cells
that i want people to be able to change, then i make the
object
non-printable (Cause i don´t want theese areas to look
different when user
print out the form), but when i ad the object it comes
over the cells ... so
i can´t choose those cells with the mouse, only with
TAB,.... this is my
problem... i hope you understand it.

Is there anyother solotion or should i just do something
in the above
different?
What i want: make my spreadsheet easier to fill ... but
when user print it
... i want it just black and white no other colors.

Regards

dase
 
R

RagDyeR

<"when user print it
... i want it just black and white no other colors">

Go to <File> <PageSetUp> <Sheet> tab,
And click on
"Black & White".

Now, just choose any color for the "unlocked" cells.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi

I am making an Excel template for others to use, now i
have locked areas
where users shoudn´t be abel to write in, but i still
want to make it clear
for users where they can enter data, to make it easier to
fill out the form.
I have tried to insert an rectangular object that i paint
yellow over cells
that i want people to be able to change, then i make the
object
non-printable (Cause i don´t want theese areas to look
different when user
print out the form), but when i ad the object it comes
over the cells ... so
i can´t choose those cells with the mouse, only with
TAB,.... this is my
problem... i hope you understand it.

Is there anyother solotion or should i just do something
in the above
different?
What i want: make my spreadsheet easier to fill ... but
when user print it
... i want it just black and white no other colors.

Regards

dase
 
Top