Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-03-2022, 11:25 PM
Kiwi971 Kiwi971 is offline Conditional format  a table cell based on percentage range Windows 10 Conditional format  a table cell based on percentage range Office 2016
Novice
Conditional format  a table cell based on percentage range
 
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
Reply

Tags
conditional formatting, ms word, tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format  a table cell based on percentage range 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:26 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft