Marking cells in Excel with too long text
Thread poster: Jerzy Czopik

Jerzy Czopik  Identity Verified
Germany
Local time: 13:51
Member (2003)
Polish to German
+ ...
Jun 10, 2007

I have an Excel file, where the translated text may not be longer as the source text.
I know how to et up the function for text length, but I don't know how to use this to mark the corresponding to long cell in colour, in order to easily find it.
Using red negative numbers as result for the length function is of course an option, but it is insufficient in long files with a lot of columns.

There must be a quite easy solutin for that, but I did not found out how this can work.

MTIA
Kind regards
Jerzy


Direct link Reply with quote
 

Claudia Digel  Identity Verified
Germany
Local time: 13:51
English to German
+ ...
Try 'Conditional Formatting' Jun 10, 2007

Hi Jerzy,

If I've understood your problem correctly, 'Conditional Formatting' is what you are looking for. You will find this option in the 'Format' menu. (In case you use a German version of Excel, it's called 'Bedingte Formatierung'.)

You will then get a dialog box in which you can set conditions (depending on the formula you are using, 'Cell Value is greater than =' might be a good option for your case) and choose format (e.g. a cell colour) that will be applied to the cells if the condition is true.

Hope this helps.

Best regards,
Claudia


Direct link Reply with quote
 

Jerzy Czopik  Identity Verified
Germany
Local time: 13:51
Member (2003)
Polish to German
+ ...
TOPIC STARTER
Thank you Jun 10, 2007

Indeed it looks like what I was looking for.
Many thanks.

Have a nice Sunday
Jerzy


Direct link Reply with quote
 

Henrik Pipoyan  Identity Verified
Local time: 15:51
Member (2004)
English to Armenian
One more way to do it Jun 10, 2007

Hi Jerzy,

In such cases I do the following:

If the original is in column A, and the translation in column B, than in column C I put the following formula:
=IF(LEN(B1)*=LEN(A1),"","Delete "&(LEN(B1)-LEN(A1)&" characters"))

* should be the less sign.(contrary to >). When I use this sign the rest of the text doesn't show up.

If the translated text is shorter or equal to the original, there is nothing in column C, but if it is longer, column C indicates how many characters need to be deleted.

[Edited at 2007-06-10 12:16]


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Marking cells in Excel with too long text

Advanced search






Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search