Conditional formatting from separate pages

[HuskerBronco]

Is there a formula I can enter into the conditional formula palette that will allow me to format cells on one sheet based on a match found on a second sheet? ....or do I have to use VBA to do this??

Here, specifically, is what I am trying to do:

Sheet1 A1:AA200 contains a list of names.
Sheet2 A1:A200 consists of a Range named MALE.
Sheet2 B1:B200 consists of a Range named FEMALE.

Consider, first...that some of the cells in BOTH named ranges may be blank.

I want to format all of the cells in Sheet1 A1:AA200 to turn green if a match is found in the Range named MALE....and turn the cells red if a match is found in the Range named FEMALE.

When I try to use the Range names in my formula...I get various errors.

Please advise me if I need to use VBA to accomplish this. Writing VBA to do this should be relatively simple...but I would appreciate some sample code to use as a model, since my VBA coding skills are still in their infancy.

Thanks, in advance, for any help you can give me.