Please see the picture.
I want to change the color of all the digits before / and incl. / to white in the cells.
Is that possible? Or maybe give them a style so I later can change the color?
If anyone want to try it out, here is a cs5 doc :
(Untested) Add a GREP style to the paragraph style used in the cells that sets your 'white' (*) color with a character style. Use this GREP:
(*) It's better not to use a literal color "white", but "None" instead. "White" will insert white text in your document -- visible if you add a background color, and selectable in your PDF. "None" will insert nothing.
Ah. The GREP looks for (start of paragraph) (any positive number of (digit or period)) (slash). The last column also contains a comma
Change the GREP to this and you should be allright:
(there's a comma added inside the square brackets)
Europe, Middle East and Africa