mikeryan44
New Member
- Joined
- Sep 4, 2002
- Messages
- 6
We create pages of financial data and send them to another office for worldwide distribution. The pages sometimes contain junk data at the end of a line, like ">" and "[" should not.
I have created a spreadsheet with DDE links to the last two characters of each line on each page, which should always be blank. When we see a value pop in at the end of a line, we go into our pagebuilding processes and remove it there. (hopefully the developers will get this fixed soon!)
My question in the meantime is this: Is there a way for Conditional Formatting to be set up so the cells go red when foreign characters come in?
This would make it lot easier to notice when this happens.
I have created a spreadsheet with DDE links to the last two characters of each line on each page, which should always be blank. When we see a value pop in at the end of a line, we go into our pagebuilding processes and remove it there. (hopefully the developers will get this fixed soon!)
My question in the meantime is this: Is there a way for Conditional Formatting to be set up so the cells go red when foreign characters come in?
This would make it lot easier to notice when this happens.