Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-02-2022, 07:09 AM
macropod's Avatar
macropod macropod is offline Conditional format  a table cell based on percentage range Windows 10 Conditional format  a table cell based on percentage range Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
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

Depending on your requirements, this can be done via field coding or a macro.



However, since you haven't told us anything about the mechanism by which these cells get populated, it's impossible to give any advice specific to your situation.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-02-2022, 11:28 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 Conditional format a table cell based on percentage range

Quote:
Originally Posted by macropod View Post
Depending on your requirements, this can be done via field coding or a macro.

However, since you haven't told us anything about the mechanism by which these cells get populated, it's impossible to give any advice specific to your situation.
Sorry, I have a document that I've mail merged from an excel document.
The word document has 4 or 5 tables.
I want to apply a conditional format to table 4 row 2 (only one cell)

In the cell below YOUR CHILD’S ATTENDANCE PERCENTAGE IS...
There is a percentage (merged field) this cell is what I want to conditionally format where the cell is filled with colour (according to the outline below).

RED = <91.99%
AMBER = >=92% <=93.99%
GREEN = >94%
Attached Files
File Type: docx SAMPLE.docx (26.6 KB, 5 views)
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 06:34 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