254 shaares
3 results
tagged
conditional
Whether you obtain data from an external source or have someone performing data entry, mistakes can happen. If you’re concerned that you may have duplicate data in Microsoft Excel, you can find out quickly with conditional formatting.
In this example mail merge is being used to format a merge field in red if the value is greater than 20, and if not; format the merge field in black.