Excel cells with green background color
Thread poster: Heinrich Pesch

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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »



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