0

I've got a particular group of mergefields that I'm trying to colour using conditional formatting.

Basically, this column with the table is a percentage and I need it coloured red if it's below zero and green if it's above zero. However, as this percentage was not available for every entry, it can also appear as "No data", which I would like coloured in black.

Unfortunately, "No data" ends up in green every time. I'm following the instructions from this previously asked question, but I guess mine might be a bit different.

I would appreciate if someone could help me with this. I'm using MS Word 2016, if that makes a difference. Thanks in advance.

NickB
  • 3

1 Answers1

0

You can use two independent IF Fields since there is no overlap.

Screenshot of field

You can convert the text shown below into a pair of fields using Graham Mayor's utility.

{ IF { MERGEFIELD Field } < 0 "{ MERGEFIELD Field \* CharFormat}" "" }{ IF { MERGEFIELD Field } > 0 "{ MERGEFIELD Field \* CharFormat }" "" }

You will have to add the color yourself. (The second set of quotation marks in each IF field is not really required.)

Here is my article on the Microsoft site on dealing with fields.

If there is overlap, you will need one or more nested IF fields. These are more complex, with one IF field inside another. A second IF field acts as the falsetext part of the first field. Here is my article on one way of constructing nested IF fields.

Charles Kenyon
  • 5,364