you only need to add Conditional format to "E" range.
=COUNTIF(Sheet2!$A$1:$A$7,$E1)<1
see this demo. on the ribbon->home->Conditional Format->Manage.
https://www.dropbox.com/s/kiwjdesi2r...rmat.xlsx?dl=0
you only need to add Conditional format to "E" range.
=COUNTIF(Sheet2!$A$1:$A$7,$E1)<1
see this demo. on the ribbon->home->Conditional Format->Manage.
https://www.dropbox.com/s/kiwjdesi2r...rmat.xlsx?dl=0
Reply With Quote
