Excel cells with green background color
Thread poster: Heinrich Pesch

Heinrich Pesch  Identity Verified
Finland
Local time: 02:07
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: 00:07
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






BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running, helps experienced users make the most of the powerful features, ensures new

More info »



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