Thread: [Solved] Conditional format a table cell based on percentage range
View Single Post
 
Old 10-03-2022, 05:42 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In which case you don't need a macro - all you need is some field coding. See Conditionally Format Mailmerge Output, Conditionally Shade Table Cells, and Conditionally Colour/Shade Numeric Output Ranges in the Mailmerge Tips & Tricks 'Sticky' thread at the top on the Mailmerge forum, to which I've moved your thread. Any of those approaches can be leveraged to achieve the desired result.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote