View Single Post
 
Old 10-02-2022, 11:28 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 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, 3 views)
Reply With Quote