[MaxArk[_4_]]

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

[WordBanter AI]

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.

[Jay Freedman]

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.

[macropod]

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