![]() |
|
#7
|
||||
|
||||
|
There is no event associated with the change of value in a table cell that will format the cell colour automatically in Word.
Using a content control to select the value, the on exit event of that control can be used, as in the example, to format according to the value when you tab out of the control. The same event can be used with multiple controls as required. The other less attractive option relies on the correct values to be entered in the table cell(s) and then subsequently run a macro to format the cell(s) based on the value(s) entered.This is hardly seamless.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Cell fill based on conditional formatting
|
allex011 | Excel | 7 | 07-07-2021 10:30 AM |
| Conditional format a button based off a value in a field | Triscia | Misc | 0 | 03-11-2015 11:12 AM |
| Conditional Formatting based on Value of Another Cell | SteveBump | Excel | 3 | 03-07-2014 09:16 AM |
How can I count cells based on their fill color that was set by conditional format
|
trueimage | Excel Programming | 1 | 10-25-2013 12:08 PM |
| Table with Conditional Format to Word | billyV | Excel | 9 | 06-07-2013 08:26 AM |