MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 216|Reply: 0

Conditional formatting in excel/word

[Copy link]

2

Topics

2

Posts

14

Integral

Member

Rank: 2

Integral
14
Post on 12-2-2016 07:47:52 | All posts |Read mode
I tried the wordbanter forum and got no replies.   Hope ok to post here.  I am doing mail merge from excel database and when the AGE field comes into word I toggle and wanted to add the code below but I get as far as below and all I get back is the word RED.  I wanted age data to go red if age is more than 20
Apologies if in wrong forum but I cant seem to get answers anywhere?
Steve
Below

One way to do simple formatting of this kind is to use an IF field to
insert the mergefield with one format or another, e.g. insert
{ IF { MERGEFIELD Age}  20 { MERGEFIELD Age} Red{
MERGEFIELD Age} }
then colour the second { MERGEFIELD myfield } (the one immediately after
the A) yellow.
All the {} need to be the special field code braces that you can insert
using ctrl-F9.
Reply

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:24 , Processed in 0.251635 second(s), 21 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!