Excel cells with green background color
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Local time: 11:17
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 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?


Neta L
United Kingdom
Local time: 09:17
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:

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

Excel cells with green background color

Advanced search

CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »
SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »

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