Follow

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use
Contact

Google Sheets Conditional Formatting By Compare Two Columns From Different Worksheets

I am having data in two different sheets i.e. Sheet1 Col A and Sheet2 ColA, I want to highlight value in Sheet1 if the count of that value in Sheet1 is less than the count in Sheet2. E.g. in Sheet1 the count of number 1 is 5 and in Sheet2 the count of number 1 is 7 thus 1 should be highlighted in Sheet1. For ease of reference am sharing the image as well as the link of the sheet with desired result.
enter image description here

https://docs.google.com/spreadsheets/d/1bFhqJ_RIzf9J5vLD3PxTxSkv0KtNp1-xW6IxD_I8b4k/edit#gid=143258355

Any help on above will be greatly appreciated.

MEDevel.com: Open-source for Healthcare and Education

Collecting and validating open-source software for healthcare, education, enterprise, development, medical imaging, medical records, and digital pathology.

Visit Medevel

>Solution :

use:

=COUNTIF($A$2:$A,$A2)<COUNTIF(INDIRECT("Sheet2!A2:A"), $A2)
Add a comment

Leave a Reply

Keep Up to Date with the Most Important News

By pressing the Subscribe button, you confirm that you have read and are agreeing to our Privacy Policy and Terms of Use

Discover more from Dev solutions

Subscribe now to keep reading and get access to the full archive.

Continue reading