Hi all,

was wondering if someone was able to help me out?
I want to conditionally format a cell in a table in MS Word based on a percentage range

Red >=91.99%
Amber 92% - 93.99%


Green >=94%

I've read a couple of threads about VBA, but VERY VERY new to it all.

HELP!!!!

Thanks in advance

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]

You could also incorporate an Excel part in your document. Conditional formatting is far easier in Excel.

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

SAMPLE.docx (26.6 KB, 5 views)

In which case you don't need a macro - all you need is some field coding. See Conditionally Format Mailmerge Output, Conditionally Shade Table Cells, and Conditionally Colour/Shade Numeric Output Ranges in the Mailmerge Tips & Tricks 'Sticky' thread at the top on the Mailmerge forum, to which I've moved your thread. Any of those approaches can be leveraged to achieve the desired result.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Is there a way I can add that to the field coding I have in there already?
I currently have {=«Percent»*100 \# 0.00%}.

So based on whatever this results spits out, I want to shade the cell according to the % range I mentioned earlier?

Thanks a million for all the support

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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!