![]() |
|
#7
|
||||
|
||||
|
Quote:
{QUOTE {SET Val {={MERGEFIELD Percent}*100 \# 0.00 }}{=INT(Val-93) \# "'→↵ {Val} →';' →↵ {Val} →';' →↵ {Val} →'"}"}}% where the relevant highlight colours are applied to the field coding according to the colouring (we can't do highlighting here) and each cell to be shaded has: • margins set to 0 all round • paragraph formatting with a single right-aligned tab-stop set to at least the cell width. Note: The spaces shown in the field constructions are all required. Instead of the → and ↵ symbols shown above, you should use real tabs and line/paragraph breaks, respectively.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Tags |
| conditional formatting, ms word, tables |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
How to conditional format a table cell in word based on it's value.
|
JulianS96 | Word VBA | 9 | 10-20-2021 02:25 AM |
| Need Conditional based percentage formula! | jocky6688 | Excel | 5 | 03-15-2021 12:35 AM |
| Conditional Formatting on cell values outside of a designated range based on category denoted in key | interntime | Excel | 3 | 05-21-2018 10:15 PM |
| Floating date range on a conditional format | Old | Excel | 2 | 06-22-2017 08:32 AM |
| Conditional format a button based off a value in a field | Triscia | Misc | 0 | 03-11-2015 11:12 AM |