Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
EdG2015 EdG2015 is offline
Junior Member
Posts: 2
Default Colour Coding Table Cells in Multiple Tables in One Document

Hi all,

I've searched all over and can't find something that's giving the results that I want, so any assistance would be greatly appreciated!

I am creating a document in Word 2010 which has around 20 tables in it each of which is of varying size. I need to apply something akin to conditional formatting in Excel which will vary for each table. For example, I want one table to format cells (using excel-type references) C3, F3, I3 and L3 with red text if 80%, amber if 80-99.99% and green if 100%. Another table I want to format anything in row 4 which is a negative as red 0-3 as amber and 4 or more in green.

I know that I could embed excel sheets within the document but this doesn't fit with what I want to achieve, so am looking for a word solution either through VBA or otherwise. If using VBA, would appreciate if someone could point me in the direction of identifying individual tables in the document so the right formatting is applied to the right table. Apologies if this is a pretty dim question - Word is not my natural environment!

Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you create a formula from cells in multiple tables? Marilyn75287 Tables 4 May 30th 09 02:31 AM
Adding Numbers of Multiple Cells in a Table Bettina Microsoft Word Help 7 July 5th 07 06:46 PM
Creating a TOC from multiple cells of a table. Scott Tables 2 October 26th 06 08:43 AM
color coding cells motocrossed Tables 1 April 28th 06 10:23 AM
I want text from the cells in one table repeated in other tables Reg Tables 2 February 14th 06 01:53 PM

All times are GMT +1. The time now is 03:46 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Word"