I have an excel sheet with 5000 rows that needs to be formatted in Indesign.
1. Is there a way to get a certain color fill of the cell depending on text. Lets say if the text is "apple", the cell should fill with red (and text also color red to make it disappear).
2. How do I make two different character styles to appear in the same cell (information is tab-separeted but sometimes I would like to have 2 "paragraphs" in one cell sometimes – with that I mean two tab-delimited cells from excel to appear in ONE cell in indesign).
Thanks in advance
Example of what I would like to accomplish: http://tinypic.com/r/vo4och/6