Technical forums » Office applications »
Excel cells with green background color
Thread poster: Heinrich Pesch
Heinrich Pesch
Heinrich Pesch  Identity Verified
Finland
Local time: 08:24
Member (2003)
Finnish to German
+ ...
Sep 28, 2017

I have to translate an Excel table with two columns. The first (A) is the source language and the second (B) it the target language.
But there are many cells in the target column already translated earlier. And in the A-column some cells should not be translated. In fact only such cells in A should be translated, where the corresponding cell in B has a green background color and is empty.
I wonder if I could use a formula that would set the font color of a cell in column A RED, if th... See more
I have to translate an Excel table with two columns. The first (A) is the source language and the second (B) it the target language.
But there are many cells in the target column already translated earlier. And in the A-column some cells should not be translated. In fact only such cells in A should be translated, where the corresponding cell in B has a green background color and is empty.
I wonder if I could use a formula that would set the font color of a cell in column A RED, if the corresponding cell in B is green and empty.
Or instead could a hide all cells in A if the corresponding cell in B is green and empty?
Excel 2016.
Any Excel wizard around? ▲ Collapse
 
Neta L
Neta L
United Kingdom
Local time: 06:24
English to Hebrew
+ ...
You can use filters Sep 28, 2017

In the "Data" tab, click the "filter" button.
You should then have drop-down menus showing at the top of each column. Go to the one at the top of column B, and you can filter both by content, unticking everything but "blank", and by colour.
 


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

Moderator(s) of this forum
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Excel cells with green background color






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
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

Buy now! »