For a demonstration of conditionally highlighting table cells according to their values, see:
https://www.msofficeforums.com/word-...html#post47254
Some modifications to the code will be needed for your requirements, but what's there will point you in the right direction. If you need more help, post back with a sample document, your code and some representative data (delete anything sensitive). You do this via the paperclip symbol on the 'Go Advanced' tab.

PS: Please post Word-related threads in the appropriate Word forum, not in the Office forum.

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