![]() |
#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 | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |