Conditional formatting of a table - word
Solved
Ducoduc
Posted messages
167
Status
Membre
-
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello everyone,
I am currently working on a Word (2016) document in which I have several tables (not linked to Excel, I emphasize). My wish is to automatically modify the formatting (background color) of certain cells based on their values. I have considered 2 solutions, which I think are viable, but which still pose a problem for me:
1- Create a macro using the recorder and use the 'replace with' function. But I cannot seem to select only the cells I am interested in (the last column in this case) and it changes text that should not be altered. Moreover, I do not know if it is possible in this way to add/modify the background of the cell; I have only managed to change the font of the text.
2- Create a macro with the following structure:
If cells XXXX take the value YYYY, then apply the green color to those cells.
Problem: I absolutely do not know how to do this, especially for choosing which cells to check.
What do you think of these solutions, which one seems most suitable to you? Do you have any suggestions to help me solve these problems?
I am attaching the type of file, in case it can be useful.. https://www.cjoint.com/c/HBhqb1GoSRV
A big Thank you :)
Ducoduc
I am currently working on a Word (2016) document in which I have several tables (not linked to Excel, I emphasize). My wish is to automatically modify the formatting (background color) of certain cells based on their values. I have considered 2 solutions, which I think are viable, but which still pose a problem for me:
1- Create a macro using the recorder and use the 'replace with' function. But I cannot seem to select only the cells I am interested in (the last column in this case) and it changes text that should not be altered. Moreover, I do not know if it is possible in this way to add/modify the background of the cell; I have only managed to change the font of the text.
2- Create a macro with the following structure:
If cells XXXX take the value YYYY, then apply the green color to those cells.
Problem: I absolutely do not know how to do this, especially for choosing which cells to check.
What do you think of these solutions, which one seems most suitable to you? Do you have any suggestions to help me solve these problems?
I am attaching the type of file, in case it can be useful.. https://www.cjoint.com/c/HBhqb1GoSRV
A big Thank you :)
Ducoduc
1 réponse
Hello Ducoduc.
The term Conditional Formatting is reserved for Excel.
For a Word table, and to avoid misunderstandings, it would be better to mention conditional cell coloring.
By the way, why don't you just use INSERT/Table/Table/Excel Spreadsheet instead?
--
Retirement is great! Especially in the Caribbean... Raymond (INSA, AFPA)
The term Conditional Formatting is reserved for Excel.
For a Word table, and to avoid misunderstandings, it would be better to mention conditional cell coloring.
By the way, why don't you just use INSERT/Table/Table/Excel Spreadsheet instead?
--
Retirement is great! Especially in the Caribbean... Raymond (INSA, AFPA)