google spreadsheet - Highlight cell if same value present in another sheet's cell -

example - client has master list of client's hosted domains in sheet 1.

client keeps list of actual record verified domains in use in sheet 2.

what need highlight domains in sheet 2 match domains in sheet 1 using color, , highlight domains in sheet 2 different color if not appear in sheet 1.

(domains in master list match record entered domains in sheet 1 appear in green, domains not match list appear in red)

the column names on both sheets "domain".

add helper columns in each, h, formulae like:

=--countif(sheet1!b:b,b1) >0  

copied down suit (assuming domains in columnb - change sheet1 suit actual sheet names).

then apply conditional formatting rules of:

=h1   

and:

=h1<>true  

to ranges b:b

with colours suit.

correction

the above based on misreading question (i thought highlighting apply each sheet): instead please try, in h1 of sheet2 , copied down suit:

=--countif(sheet1!b:b,b1) >0  

and these 2 rules:

where first is:

=and(h1<>"",h1<>true)   

(the first part of avoid blank cells being highlighted).