Conditional Formatting

You may already use conditional formatting rules in your Excel spreadsheets. It's a really useful way of highlighting particular pieces of information, to help readers to understand what's important.  Now eaDocX brings the power and simplicity of Conditional Formatting to your Word documents.

Each of your documents will have different information which you might want to highlight to a reader. It may be missing information, values which are too large or too small. Or the value stored in EA needs changing but just for one report. For example, EA uses 'Proposed' and 'Approved' as the default status values. You might want to print 'Initial' and 'OK' instead. Conditional Formatting can do this for you, every time a documents is created, and without changing your EA model.

You can add Conditional Formatting to Inline text, tables, element- and matrix-reports:



Inline text

In this example, we have decided to highlight all 'Jackie' issues in Yellow, and and all Ian ones in Green.

We have also added a rule which should help us to maintain the quality of our model. In this case, all issues should have a unique ID in the 'Alias' field. If it's missing, that's an error, so we highlight that in red.







In a table

In this table, we have also created rules which look for mistakes in the model, again by highlighting a missing 'Ref' (Alias) value in red.

Here we have decided to highlight Components which will be deliverd in Phase 2 in Yellow, and ones which have a status of "Signed-off" in green.





In a Matrix report

In this example we have created rules both to color the cells which have valid relationships, and used some replacement text.

In the orignal model, the cells have a value which is the stereotype of the relationship, whch was either 'Priority' or 'Implemented', but this was too long to fit into a little cell in this table.

So we created Conditional Formatting rules in the Matrix Reports to replace 'Priority' with just 'P', and another rule to colour it Yellow.

We also coloured relationships with no value in red, and made the text '?', also with a Conditional Formatting rule.

We think this makes it easier to see what's important in this table. 

An all this was done with NO CHANGES to our EA model, and everythig will update as the model changes as we re-generate the document.

For more on Conditional Formatting, see the eaDocX Help.