Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Menus and Toolbars / December 2006

Tip: Looking for answers? Try searching our database.

Conditional formatting and changing the grey form field shading

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bluegrassstateworker - 15 Dec 2006 18:52 GMT
I have a spreadsheet with conditional formatting where the background
of the cell is yellow until something is input.  Once input, the
background turns to white.  I use this to be able to visually verify
that important cells were not overlooked.  Within this spreadsheet I
have an embedded Word document containing form fields placed in a table
that I would like to have mimick the conditional formatting in the
spreadsheet.

Ideally, the shading on the form field would be yellow and that would
suffice.  I have not seen any new posts that provide a solution but any
thoughts welcome.  I have Word2003 SP2.
Graham Mayor - 16 Dec 2006 06:48 GMT
You could highlight the field with yellow colour, but form field shading
will always be grey.
If the standard highlight colours won't suffice - see
http://gregmaxey.mvps.org/Highlighter.htm
Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor -  Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have a spreadsheet with conditional formatting where the background
> of the cell is yellow until something is input.  Once input, the
[quoted text clipped - 7 lines]
> suffice.  I have not seen any new posts that provide a solution but
> any thoughts welcome.  I have Word2003 SP2.
CyberTaz - 16 Dec 2006 19:43 GMT
Perhaps I'm reading too much into your request, but if you *do* want the
shading in the Word object to be conditional you will need some VBA to
accomplish it. There is no inherent feature in XL or Word that will trigger
conditional changes in embedded objects.

Regards |:>)
Bob Jones
[MVP] Office:Mac
bluegrassstateworker - 21 Dec 2006 19:05 GMT
Right now, the form field shading in Word is grey and I would like for
it to be yellow.  I know with earlier versions, a colour option was not
available.

> Perhaps I'm reading too much into your request, but if you *do* want the
> shading in the Word object to be conditional you will need some VBA to
[quoted text clipped - 4 lines]
> Bob Jones
> [MVP] Office:Mac
Suzanne S. Barnhill - 21 Dec 2006 20:06 GMT
There is no option other than grey.

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Right now, the form field shading in Word is grey and I would like for
> it to be yellow.  I know with earlier versions, a colour option was not
[quoted text clipped - 8 lines]
> > Bob Jones
> > [MVP] Office:Mac
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.