conditional formatting
 

i have two list i need to fill all the all names that appear in both lists
green and the names that appear only on one of the lists orange how do you do
it ???

conditional formatting
 

Assume List1 is in A1:A100
Assume List2 is in B1:B100

Highlight all the data and color it orange.

Now highlight A1:A100, then click Format Conditional Formatting

Condition1: Formula Is: =COUNTIF($B$1:$B$100,A1)0
Format: Pattern: Green OK OK

Now repeat with B1:B100 with this formula in CF:
=COUNTIF($A$1:$A$100,B1)0

This will turn matching names green.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"eric" wrote:

i have two list i need to fill all the all names that appear in both lists
green and the names that appear only on one of the lists orange how do you do
it ???