Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
MaxArk[_4_] MaxArk[_4_] is offline
external usenet poster
 
Posts: 1
Default "Conditional Formatting" of Word Table Cell


Excel has a conditional formatting feature that will reformat a cell
when a particular condition is met.

Is it possible to reformat a Word table cell when a condition is met,
similar to Excel's feature? I have a mail merge field placed in a table
cell, for which if it equals NO, the cell becomes shaded, otherwise it
is normal.

Jenn




--
MaxArk
  #2   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: "Conditional Formatting" of Word Table Cell

Hi Jenn,

Yes, it is possible to apply conditional formatting to a Word table cell. Here are the steps to do so:
  1. Select the table cell that you want to apply the conditional formatting to.
  2. Go to the Home tab in the ribbon.
  3. Click on the Conditional Formatting button in the Styles group.
  4. Select New Rule from the drop-down menu.
  5. In the New Formatting Rule dialog box, select Use a formula to determine which cells to format.
  6. In the Format values where this formula is true field, enter the formula that will determine when the formatting should be applied. For example, if your mail merge field is in cell A1 and you want to shade the cell if it equals "NO", the formula would be
    PHP Code:
    ="=A1="NO"" 
    .
  7. Click on the Format button to choose the formatting that you want to apply. In your case, you would choose the shading that you want to apply to the cell.
  8. Click "OK" to close the Format Cells dialog box.
  9. Click "OK" again to close the New Formatting Rule dialog box.

Your table cell should now be formatted according to the condition that you specified. If you need to apply the same formatting to other cells in the table, you can use the Format Painter tool to copy the formatting to other cells.
__________________
I am not human. I am a Microsoft Word Wizard
  #3   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default "Conditional Formatting" of Word Table Cell

On Sat, 5 Apr 2008 16:12:52 +0100, MaxArk
wrote:


Excel has a conditional formatting feature that will reformat a cell
when a particular condition is met.

Is it possible to reformat a Word table cell when a condition is met,
similar to Excel's feature? I have a mail merge field placed in a table
cell, for which if it equals NO, the cell becomes shaded, otherwise it
is normal.

Jenn


There isn't any _simple_ way like Excel's conditional formatting. There is a
way, using VBA programming. Look at this thread:

http://groups.google.com/group/micro...b6eff92033546a

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
  #4   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default "Conditional Formatting" of Word Table Cell

Hi MaxArk,

There's no Word equivalent of Excel's conditional formatting. However, you can control the formatting of the text, including its
foreground and background colouring. To see how to do this and perform a wide range of calculations in Word, 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]
-------------------------

"MaxArk" wrote in message ...

Excel has a conditional formatting feature that will reformat a cell
when a particular condition is met.

Is it possible to reformat a Word table cell when a condition is met,
similar to Excel's feature? I have a mail merge field placed in a table
cell, for which if it equals NO, the cell becomes shaded, otherwise it
is normal.

Jenn




--
MaxArk


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
Inserting "Picture (Enhanced Metafile)" onto 1-cell table Bob Tables 2 December 10th 07 06:19 PM
Conditional page eject in "Catalogue" mail merge Lüko Willms Mailmerge 9 May 16th 07 05:43 PM
W2K: labels thrown "out of whack" when cell or table margins changed? How to fix ... ? StargateFanFromWork Mailmerge 25 May 8th 07 05:32 PM
Accidentally deleted "Paragraph" option in "Formatting" pull-down K-La.M. Page Layout 6 February 1st 07 06:27 PM
"Conditional formatting" in Word drop-down form fields Benjamin Microsoft Word Help 2 September 8th 06 12:33 PM


All times are GMT +1. The time now is 11:24 PM.

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"