Color Conditional Formating

[htchandler]

I have to Worksheet A and Worksheet B. I need names on Worksheet A to change color if and only if they appear on worksheet B. Is that possible?

 

[jeffreybrown]

Name the list on Worksheet B WrkShtB and then on Worksheet A highlight the range and in conditional formatting enter =MATCH(A1,WrkShtB,0)

 

[bryonwoods30]

are the names in one column on each worksheet? how are they laid out on each sheet?

 

[htchandler]

Names are in Column J on Worksheet A and in Column A on Worksheet B. I've looked all through the conditional formating options>Highlight Cell rules>equal to, but cannot see a way I can write in a formula regarding cell formatting.

 

[jeffreybrown]

What version are you running...2007?

 

[jeffreybrown]

If 2007...

1. Go to Worksheet B >> highlight the list of names to check against
2. In the name box, above column A, type in WrkShtB and press enter
3. Go to Worksheet A >> highlight the list of names to highlight if a match
4. Home tab >> Conditional Formatting >> New Rule >> User a formula to determine which cells to format
5. Edit the Rule Description:
6. ​
   Format values where this formula is true:
7. ​
   Enter =MATCH(J1,WrkShtB,0)
8. Pick Format >> OK