conditional formatting word table numbers

Question

Hello, i need to format a table in a word document. The first condition is that if a BP is less than 139/79 it will be green, if it is over 140/80 it will be red. This is shown as <LatestBP> in the table.

The second is that is cholesterol is less than 3.9 it is green, if it is over 4, it is red. This is shown as <Numerics(table)> in the table.

I have found codes and tried them but I keep getting errors and don't know enough to be able to correct them.

I have tried to do macros and also the IF field, neither of which i can do successfully.

Any help would be greatly appreciated.

Emma

Answer 1

When you paste from Excel to Word you should see a small button at the lower right corner. Choose to keep source formatting.

Answer 2

If you showed us how you are trying to do it we may be able let you know if that approach is feasible and how to fix it.

However, while I am not sure that it can be done on a Mac, but I would have the values entered into Content Controls and then use the ContentControl on Exit event to determine what formatting should be applied to the content control.

You may need to use two content controls for the blood pressure and it would be easier if just the systolic value was used to make the determination.  Alternatively, what would you want done if the systolic value was greater that 140, but the diastolic was less than 80? or vice versa?

Answer 3

Hi sorry but i have no idea what that means? Im fine with doing conditional formatting on excel but i cant just copy and paste the table into word and keep the formatting

Answer 4

Hello emmasimpson1. MS Word tables do not handle conditional formatting. MS Excel can do conditional formatting. Put your data in Excel, and either Link your Excel file to MS Word document or Embed it. If you link it, changes in Excel will change in Word.

I tested and it worked. Copy your data from Excel, and when you right-click in Word, select "Link & Keep Source Formatting". This keeps the colors from the conditional formatting you did in Excel.

One more tip. You need to break out your BP numbers. I would have the top number, 139 as an example in one column and the bottom number 79 in another column. Don't put them in the same column.

Answer 5

You can embed an Excel range into your Word document. This would be the easiest solution, because Excel includes native support for conditional formating.