Conditional format a table cell based on percentage range

Kiwi971 · #3 10-02-2022, 11:28 PM

Quote:

Originally Posted by macropod

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%

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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