Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Under Pressure Under Pressure is offline
external usenet poster
 
Posts: 1
Default how to conditional format in a Word table

I can do a mail-merge but I need to be able to colour the background of cells
according to the values placed in them. No problems in Excel, but Word?
  #2   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default how to conditional format in a Word table

Word doesn't do conditional formatting, but you can embed an Excel sheet in
Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Under Pressure" Under wrote in message
...
I can do a mail-merge but I need to be able to colour the background of
cells
according to the values placed in them. No problems in Excel, but Word?



  #3   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default how to conditional format in a Word table

Hi 'Under Pressure',

If the values you're referring to are numbers, you could use a numeric picture switch to change the colours and other attributes of
the fonts, and the background colours for the values themselves. Not what you're asking for, but it might suit your needs. To see
how, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Formatting Numeric Field Results'

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Under Pressure" Under wrote in message
...
I can do a mail-merge but I need to be able to colour the background of cells
according to the values placed in them. No problems in Excel, but Word?


  #4   Report Post  
Posted to microsoft.public.word.tables
Under Pressure[_2_] Under Pressure[_2_] is offline
external usenet poster
 
Posts: 2
Default how to conditional format in a Word table

Suzanne

I kind of figured this out. Thanks anyway. However, I've decided to type
my template that was in Word into a spreadsheet and then write a Macro to put
the data from my spreadsheet into this spreadsheet template. Wish me luck!!

Under Pressure

"Suzanne S. Barnhill" wrote:

Word doesn't do conditional formatting, but you can embed an Excel sheet in
Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Under Pressure" Under wrote in message
...
I can do a mail-merge but I need to be able to colour the background of
cells
according to the values placed in them. No problems in Excel, but Word?




  #5   Report Post  
Posted to microsoft.public.word.tables
Under Pressure[_2_] Under Pressure[_2_] is offline
external usenet poster
 
Posts: 2
Default how to conditional format in a Word table

Thanks macropod

Didn't enjoy working with switches - not reall a Word specialist. However,
I am going to type my Word template out into a spreadsheet and then write a
macro to copy the data from the spreadsheet into this template. It works on
a simple test that I did - but whether it works on 300 lines of data
remains to be seen.

Cheers

Under Pressure

"macropod" wrote:

Hi 'Under Pressure',

If the values you're referring to are numbers, you could use a numeric picture switch to change the colours and other attributes of
the fonts, and the background colours for the values themselves. Not what you're asking for, but it might suit your needs. To see
how, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Formatting Numeric Field Results'

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Under Pressure" Under wrote in message
...
I can do a mail-merge but I need to be able to colour the background of cells
according to the values placed in them. No problems in Excel, but Word?





  #6   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default how to conditional format in a Word table

You can use a mail merge to put data from Excel into a Word table.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Under Pressure" wrote in message
...
Thanks macropod

Didn't enjoy working with switches - not reall a Word specialist.
However,
I am going to type my Word template out into a spreadsheet and then write
a
macro to copy the data from the spreadsheet into this template. It works
on
a simple test that I did - but whether it works on 300 lines of data
remains to be seen.

Cheers

Under Pressure

"macropod" wrote:

Hi 'Under Pressure',

If the values you're referring to are numbers, you could use a numeric
picture switch to change the colours and other attributes of
the fonts, and the background colours for the values themselves. Not what
you're asking for, but it might suit your needs. To see
how, check out my Word Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Formatting Numeric Field Results'

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Under Pressure" Under wrote in
message
...
I can do a mail-merge but I need to be able to colour the background of
cells
according to the values placed in them. No problems in Excel, but
Word?






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Tricky: Word Table Conditional Formatting TomorrowsMan Tables 8 April 18th 06 11:35 PM
MS Word table - problem with conditional formula Peterkins Tables 20 April 18th 06 12:18 PM
how do i format conditional text in a word mail merge surreyjed Mailmerge 1 January 28th 06 01:56 PM
Conditional format JohnM Tables 1 October 16th 05 03:18 PM
If then else with conditional format using comapre AND Dennis at Arcadia Mailmerge 1 January 25th 05 10:31 PM


All times are GMT +1. The time now is 11:21 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"