View Single Post
 
Old 10-03-2022, 11:25 PM
Kiwi971 Kiwi971 is offline Windows 10 Office 2016
Novice
 
Join Date: May 2021
Location: United Arab Emirates
Posts: 9
Kiwi971 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
No, it's not that simple. What you need is something like:

{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.
Thanks so much for your support, let me have a go at inputting this. I'm very new at this, so will probably come back with questions. First time user!
Reply With Quote