yogi_Condionallty Format Rows Where Emails Are The Same As Those in Tab Named 'Received'

Google Spreadsheet   Post  #2097

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-22-2016

question by: davieboy_cze:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ZcgXkZIOq3o;context-place=mydiscussions

Data comparation & conditional formating

 

I have 3 tabs:

- Sent

- Received

- Report

There are new rows automatically created from another software In tabs Sent and Received.

I need to:

1. compare tabs Sent and Received and highlight green every row in tab Sent where is the duplicite email (in column C) found in tab Received.

2. Count higlighted rows in tab Sent and their number insert to tab Report

Thanks in advance!

David

https://docs.google.com/spreadsheets/d/1NqYQlvmt5s4VfG_yzr9xgWaPaamNxUg0AmLKUsUTpOU/edit?usp=sharing